Sum something up with two criterias

[jleung07]

Hi,

I want to sum the things up on column C up, if column A is "A", and if column B is "<1000". How do I do that?
I am using excel 2003, so I don't think =sumifs will work. Thank you very much.

[Haseeb Avarakkan]

Hi,

Try SUMPRODUCT.

=SUMPRODUCT((A2:A1000="A")*(B2:B1000<1000)*ISNUMBER(B2:B1000),C2:C1000)

[bentleybob]

Please Login or Register  to view this content.

[jleung07]

Thanks it worked! Thank you very much!