If Column A = (certain month) Add (Column C)

Here's the dealio:

Variables:
Column A is for the month.
Column C is an amount of money.

End Result
I want to find the sum of the amounts in Column C only if Column A = a specific month

example:

april 10
may 200
april 555
june 360

TOTAL: $565

Macbook Pro, Mac OS X (10.6.3)

Posted on Mar 31, 2010 7:34 PM

16 replies

Badunit

Level 7

30,384 points

Jun 15, 2010 5:56 PM in response to Megan Renee

I can't tell you with any certainty why you are getting a zero sum because I do not know what is in the "category" or "paid" columns or in cell A2 or cell D1 in your table. I can assume D1 has a date.

=SUMIFS(paid,category,A2,date,">="&D1,date,"<="&EOMONTH(D1,0))
will sum values in the paid column where all of the following conditions are met:
1) the value in the 'category' column = the value in cell A2
2) the date in the 'date' column is on or after the date in cell D1
3) the date in the 'date' column is on or before the end of the month of the date in D1

Is it possible that A2 is not the same as any of the categories, maybe there is an extra space or a trailing space or something like that? Try taking that condition out of the formula and seeing if it will sum by the two date conditions.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

If Column A = (certain month) Add (Column C)

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up