Sumif
 

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

Sumif
 

One way: =SUMPRODUCT((A2:A10="Feb")*B2:D10)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Satin" wrote:
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