Formula to get the count of items that satisfy two conditions

[Ecel Dumbo]

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 .


http://speedy.sh/K7fUw/Book1.xls


Thanks

 

[shrivallabha]

In cell K4:


=SUMIFS($D$1:$D$22,$A$1:$A$22,$I4,$F$1:$F$22,$J4)


and the copy down this formula.