Sum based on the dates in a different row.

G

Gary

Another similar kind of problem....I have dates running from 1/1/2007 to
29/6/2007 from C2 to EB2 and I have some values in the row
14 (C14 to EB14). Now I want the sum of all the values. I want the formula
to look for month 1 in row 2 and then return the sum of all the values in
row 14. same for Feb, March, April, May and June.

I entered the following formula.

=SUM(IF(MONTH($C$2:$EB$2)=1,$C15:$EB15))

but it is adding all the values instead of adding the values of January
only. I also dragged it to next column and changed the month to 2 but in
Feb, it shows me 0 and in Jan, it also adds the Feb values.

Please help.
 
G

Guest

=SUM(IF(MONTH($C$2:$EB$2)=COLUMNS($A:A),$C$15:$EB15))

ctrl + shift + enter, not just enter
copy across the columns
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting Ps and Ls based on the date in another row. 2
Changing Sum Range Based on Date Chosen from Drop Down List 1
Define variable range input for SUM() function 8
Excel Help with dates 2
Sum Values from different column 1
using sumifs to sum based on month, and criteria 13
Sum cells using criteria from a row and a column 2
sum results based on a reference 4

Top