Sumif

[Satin]

I have a spreadsheet where I want to sum all data where Feb appears in Column A
For example: in the cell that I put the formula, I should get 18. Any
ideas?

Column A Column B Column C Column D
Jan 2 3 1
Dec 5 6 3
Feb 2 2 1
Feb 5 6 2
Apr 3 2 1

 

[Max]

One way: =SUMPRODUCT((A2:A10="Feb")*B210)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik