Use the following formula. It assumes that your data is in
A2:D10.
=SUMPRODUCT(--(A2:A10="apples"),--(B2:B10="B"),--(D2:D10))
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Mubashar" wrote in message
...
is there any option using sumif or any other formula:- I want
to sum apples
of Grade "B" QTY (multiple criteria)
FRUITS GRADE COLOUR QTY
apples A red
5
apples B red
20
apples C red
15
bananas A green 10
apples B red
50