View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
djk djk is offline
external usenet poster
 
Posts: 4
Default sum if with multiple criteria

how can I use multiple criteria and the sum if function.

how could I sum for "red apples"?

ColA ColB ColC
red apples 5
green apples 2
baby carrots 1
red apples 3

Thanks

--
djk