View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mubashar Mubashar is offline
external usenet poster
 
Posts: 1
Default I want to sum two conditions like apples of Grade "B"

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