Thread: Sum with multiple criteria

This is what I got. A spread sheet that I enter details for daily job performed.

I enter the:
Date, Amount then enter a "x" in either the cash,check, or credit card column to show how they paid.

Each entry could have multiple entries per day, so then I have a column that does an array and totals up each day by date for total sales. What I'm having trouble in is doing the same (going through by date) and getting not the total sales per day - but total sales by tender (cash or check etc.)

help??

in the spreadsheet like i said daily sales already has the right calculation but next to it where it says "daily cash" i don't know how to go about it.

Hello & Welcome to the board,

In N2 try...

=SUMPRODUCT(--($A$2:$A$200=$L2),--(D$2:D$200="x"),$C$2:$C$200)

OMG!!!
Thank you that worked perfect!!!
I've been trying all day, you rule!!