G
Guest
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
it will add the figure in column J. Is this possible?
=if(and(b=jp,d=Y),true,false)
--
Regards,
Fred
Please reply to newsgroup, not e-mail
I want to add in a formula whereby if column B = JP and column D = Y, thenyvonneb said:
it will add the figure in column J. Is this possible?
F
Frank Kabel
Hi
try
=SUMPRODUCT(--(B1:B100="JP"),--(D1
100="Y"),J1:J100)
try
=SUMPRODUCT(--(B1:B100="JP"),--(D1
100="Y"),J1:J100)
D
Domenic
Hi,
=SUMPRODUCT(--(B1:B100="JP"),--(D1100="Y"),J1:J100)
and adjust the range accordingly
Hope this helps!
=SUMPRODUCT(--(B1:B100="JP"),--(D1
100="Y"),J1:J100)and adjust the range accordingly
Hope this helps!