IF formulas and monthly finances
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
|