MULTIPLE CONDITION FORMULA

[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?

 

[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

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?

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(B1:B100="JP"),--(D1100="Y"),J1:J100)

 

[Domenic]

Hi,

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

and adjust the range accordingly

Hope this helps!