Excel formula help!

[Ant132]

I'm trying to find the right formula to give me a cumulative number based on a month in a different cell.

E.g.

Jan Feb Mar Apr May

100 50 75 80 110

I want to have 'Mar' typed in a cell, and then a formula in a different cell that tells me the cumulative number from Jan to Mar = 225.

Hope that makes sense, I thought it would be simple but maybe my brain is dead!
____________________
1980 Suzuki TS50 ~ 1984 Honda CB400N ~ 1992 Triumph Trident ~ 1998 Suzuki Bandit 1200

[Baffler186]

=IF(A1="MAR", SUM(range of data you want summed), 0)

e.g.

=IF(A1="MAR", SUM(B2:B4), 0)
____________________
Current: 2009 SV650 S, 1990 Kawasaki GT550
Previous: 2009 CBF125, 1998 GSF600, 2004 FZ6 Fazer, 1978 CB400a Hondamatic

[Ant132]

Thanks for that! But if i then change it to Apr or Jun etc. I'll have to re-adjust the formula won't I?

It's not that i'm lazy, i just dont like being defeated by computers
____________________
1980 Suzuki TS50 ~ 1984 Honda CB400N ~ 1992 Triumph Trident ~ 1998 Suzuki Bandit 1200

[Baffler186]

Yes, or you could do a separate table with each month in, copy the formulas (but change the sum:range) so they'll update themselves. Or if you want it really simple, you can just select the range you want to add up, and look down in the control bar at the bottom and in gives you the sum. As always in Excel, there are few ways you can do it
____________________
Current: 2009 SV650 S, 1990 Kawasaki GT550
Previous: 2009 CBF125, 1998 GSF600, 2004 FZ6 Fazer, 1978 CB400a Hondamatic

[metalhead41]

Try this (for reference A1 to E1 I have Jan to May, A2 - E2 is the values and J1 is where I am entering the value to be looked up)...

[el_oso]

sumif is what you want
____________________
Duke 390
Previous: '05 XR125L | '96 XJ600S Diversion |'05 Suzuki GSXR1000 | '05 Honda CBR125-R | '97 YZF 600R Thundercat | '11 Honda CBR250
Car: Jeep Wrangler 4.0L