hi David,

=SUMPRODUCT(--(MONTH($A$2:$A$100)=3)*($B$2:$B$100="maintnenance" )*($C$2:$C$100))


--
isabelle



Le 2012-06-10 09:39, dkte737 a écrit :
Hi, I need a little help with this function.

I have dates in column A (3/31/12), an categories in column B
(maintenance) and then a dollar amount in column C ($52.55).

I would like a function that would sum the dollar amounts only if the
date was in March and the catagory matched "maintnenance"

Any help?

Thanks,

David