MULTIPLE CONDITION FORMULA

Y

yvonneb

I have a spreadsheet that got text and figure data in different columns. I want to add in a formula whereby if column B = JP and column D = Y, then it will add the figure in column J. Is this possible?
 
F

Fred Smith

To use multiple conditions, use the AND function, eg:

=if(and(b=jp,d=Y),true,false)

--
Regards,
Fred
Please reply to newsgroup, not e-mail


yvonneb said:
I have a spreadsheet that got text and figure data in different columns.
Click to expand...
I want to add in a formula whereby if column B = JP and column D = Y, then
it will add the figure in column J. Is this possible?
 
D

Domenic

Hi,

=SUMPRODUCT(--(B1:B100="JP"),--(D1:D100="Y"),J1:J100)

and adjust the range accordingly

Hope this helps!
 
Top