Question
June 14, 2007 at 10:01 AM
sacf14

Help with Excel

by sacf14 . Updated 19 years, 4 months ago

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!!!!!

This discussion is locked

All Comments