Cell With Specific Text & SUM question

[Tonytonytony]

Can any Excel wizards help me with this prob:

I've got a column of about 50 amounts and another column with the month I expect the income will arrive.

I'd like to set up separate cells for each month that will automatically tally all dollar amounts in the cells that have a 'JAN', 'FEB', etc. next to them.

I'm basically wanting to project monthly GI where I can type in the estimated month I think the specific income will arrive.


Thnx!

 

[Scott Huish]

If it's actually text JAN, FEB (not dates formatted that way), you can just use SUMIF
Assuming month in Column A, and amounts in Column B.

=SUMIF(A:A,"Jan",B:B)

You can use a cell reference to hold the month if you want, say in C1
=SUMIF(A:A,C1,B:B)

 

[Tonytonytony]

@Scott Huish. . . it worked!!! Thank you so much!