Formula to get the count of items that satisfy two conditions

**Excel Dumbo** · 02-23-2013, 08:51 AM

hello,

please refer the attached worksheet. I would like to get a formula that will give the total number of units sold of a particular product for a particular price .

Thanks

**Pete_UK** · 02-23-2013, 08:58 AM

Put this formula in K4:

=SUMPRODUCT(($A$2:$A$22=I4)*($F$2:$F$22=J4),$D$2:$D$22)

then copy down. Note that it correctly calculates the final example.

Hope this helps.

Pete

**benishiryo** · 02-23-2013, 08:59 AM

hi there~ it's been awhile i last saw you. try:
=SUMPRODUCT($D$2:$D$22,($A$2:$A$22=I4)*($F$2:$F$22=J4))

but why is "TECNIS TORIC" with unit cost of $740 only 5 units? could you identify which rows they are? i got:
row 4 (x1), row 20 (x1) & row22 (x4)

**Excel Dumbo** · 02-23-2013, 04:28 PM

hi pete UK and benishriyo.....thanks heaps...it worked like magic

i am sorry....the expected answers for tencis toric i gave was wrong. u guys are spot on

it's been a long time benishriyo....

**Excel Dumbo** · 02-23-2013, 04:32 PM

Thanks Pete and Benishriyo...it worked

i am sorry the expected answer i gave for tecnis toric was wrong.

it's been a long time benishiriyo...hope u dont mind be disturbing you with lots of my silly excel doubts very soon