Try
=SUMPRODUCT(--(D8:D99="x"),--(F8:F99="x"),H8:H99)

If this post helps click Yes
---------------
Jacob Skaria


"Patti" wrote:

I have a spreadsheet that first breaksdown expenses, between centers, ie
project or ministry, then secondly by expense type, ie cash or credit card,
then I need it to sum the column with actual $. I've tried to use the IF
function but I get error message...

=IF(D8:D99="x", IF(F8:F99="x",SUM(H8:H99)))

Can anyone please help me...

Thanks so much
--
Patti Lassiter