If FRUITS begins in A2, GRADE in B2, etc, use this:
=SUMPRODUCT((A3:A7="apples")*(B3:B7="b")*(C3:C7="r ed")*(D3:D7))
easier if you use cells containing the criteria you want to sum, in lieu
of changing the formula each time.
enter apples, b, red in F1, G1, H1, respectively, then use this
formula: =SUMPRODUCT((A3:A7=f1)*(B3:B7=g1)*(C3:C7=h1)*(D3:D 7))
change the values in F1, G1, H1 to suit your tastes in fruit!




Mubashar wrote:
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