sumif
Tks for the quick response.
The spreadsheet I'm using is set up like a database.I have 2 columns for
Date. The first only shows the month, the second shows the actual date the
main. was done.
The first column is the one I need (I think).
Here's my question
For the month of January for Machine #1 what was the total cost of
maintenance?
so for every Month in column1 that = January and for every machine #1 =
column 2
sum up all cost .
I'm not sure if it should be treated as an array (I've tried both ways same
result)
Tks
"Bob Phillips" wrote:
=SUMPRODUCT((A1:A100="machine")*(YEAR(B1:B100)=200 5)*(MONTH(B1:B100)={1,2,3}
)*C1:C100)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"hellZg8" wrote in message
...
I need to keep track of maintenance on certain machines and how much it
costs.
Would like to be able to show how much was spent on each machine in a
given
month or qtr.
any Ideas
Tks
|