IF the right function? Multiple functions maybe?

[bzymom]

I am trying to get a new worksheet to refer to several columns of data and add a range of cells if certain criteria exist.

Situation: Sheet 1 contains Dates of Payments are entered into Column K. If an "x" is in column M, indicating the payment is cash, I need the formula in Sheet 3 to sum all cells in the range where dollar amounts are entered as long as the above criteria exist. I will be doing the same with dates in column k and "varied numbers" in column L for check numbers of payments. Basically, I need a deposit total of cash and check for a specific date. I have tried lots of combos and am completely lost. Please and THANK YOU for your help!

[FDibbins]

have you tried looking at the SUMIF() function?

=SUMIF(criteria range, criteria, sum range)

If this is not what you want, or you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Tony Valko]

Sounds like you want this...

Data Range

	M	N	O	P
1	Cash	Amount	------	Total
2	X	30		190
3		39
4	X	51
5	X	70
6		98
7	X	39
8		83
9		17
10		84

This formula entered in P2:

=SUMIF(M2:M10,"X",N2:N10)