Thread: sumif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default sumif

=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