IF formulas and monthly finances

[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

 

[T. Valko]

One way:

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