Software

Ask something
Question Locked

Help with Excel

0 helpful
2 replies

by sacf14

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I'm creating a template in excel. In column A i have the month (Jan, Feb...) and in Column B the expenditure. But I still cannot find a formula to sum in a new cell the expenses that correspond only to January, and in another cell just the expenses of february and so on. I have something like:
=if(a:a="JAN", SUM THE CELLS IN COLUMN B WHICH CORRESPOND TO JANUARY....
Everything is in the same sheet.
Any idea???????

Thanks!!!!!

2 replies

by leighton_linton

Assuming that the months are in column "A" and expenses are in column "B". If the emtries are in rows 2 thru 37 Try this:

=SUMIF($A$2:$A$37,"January",$B$2:$B$37)

You can also substitute a cell reference for
the month, in which case leave off the quotes. so if then text January was in cell A2, the following would yield the same results as the first example:

=SUMIF($A$2:$A$37,A2,$B$2:$B$37)

The $ sign preserves the cell range in case you want to copy the formula to create totals for subsequent months.

Hope this helps

LL

This discussion is closed to new replies.