IF formulas and monthly finances

  • Thread starter Thread starter Karl
  • Start date Start date
K

Karl

Hi,

I’m creating a spreadsheet to track the activity of my department next year.
One of the things I want to do is track the money made on a certain kind of
job, but I want to do it month by month.

So, in the relevant table on my “reports†worksheet I want to use an IF
formula to say the following:

“Look at the column “a†on the ad hoc worksheet. Calculate the total of all
the cells in column “b†for which the corresponding cell in column “aâ€
contains a date from Jan/Feb/Mar 2008 (and so on).

Can anyone tell me how this would look?

Thanks

Karl
 
One way:

=SUMPRODUCT(--(A1:A100>=DATE(2008,1,1)),--(A1:A100<=DATE(2008,3,31)),B1:B100)
 
Back
Top