View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anat
 
Posts: n/a
Default Sumif with 2 conditions

I have a spreadsheet with 3 columns:

A Blue 250
B Blue 100
B Blue 300
C Red 500
A Red 200
A Blue 50

How could I use sumif to calculate all the A and blue in one cell and A and
red in another cell. I do not want to use pivot tables.

Thanks