Hi,

Im 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)


--
Biff
Microsoft Excel MVP


"Karl" wrote in message
...
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