hi i want to know how to add multiple cells with two criteria
here is my example. im using sumif and it works with one criteria, but with two criteria what should i do ?
hi i want to know how to add multiple cells with two criteria
here is my example. im using sumif and it works with one criteria, but with two criteria what should i do ?
Last edited by verisme; 01-03-2010 at 03:17 AM.
Hi,
try SUMPRODUCT like this
=SUMPRODUCT((B4:B11="TV")*(C4:C11="GOOD")*D4:D11)
or like this
=SUMPRODUCT(--(B4:B11="TV"),--(C4:C11="GOOD"),D4:D11)
hth
thanks that solve my problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks