assuming
dates machine cost
=sumproduct((month(a2:a22)=3)*(b2:b22="machine1")* c2:c22)

--
Don Guillett
SalesAid Software

"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