Finding cash sales for specific cashier question

[easybpw]

Hello and thank you in advance for the help.

How can I accomplish this with a formula. Here's the situation.

In my spreadsheet column A shows the cashier ID and column C is supposed to show the cash sales for the cashier. Over to the right on the same spreadsheet column J shows the different tenders the cashier had that day (AMEX, VISA, CASH, etc), column L again shows the cashier ID, and column M shows the amount of sales for the specific tender. What I need to do is find a formula that puts the amount of cash sales from column M into column C. Perhaps below will be a better example.

column A column C column J column L column M

11111 ????? expected 458.3 AMEX 11111 500.25
22222 ????? expected 125.21 Cash 11111 458.3
DISCOVER 11111 320.56
VISA 22222 589.01
MASTERCARD 22222 87.23
Cash 22222 125.21

I cannot change or move the data to different columns to make it easier. And there could be many cashiers with many different tender types so column J, L, & M are very long. If the cashier didn't have cash sales and only credit cards or another type of tender then the result of the formula would be "No Cash". UGH, the formatting after submitting this doesn't show as I type this. I hope it's understandable.


Can this be accomplished?

Thanks!

Bill

 

[Fluff]

How about

Book1
	A	B	C	D	J	K	L	M
2	11111		458.3		AMEX		11111	500.25
3	22222		125.21		Cash		11111	458.3
4					DISCOVER		11111	320.56
5					VISA		22222	589.01
6					MASTERCARD		22222	87.23
7					Cash		22222	125.21
Specs

Cell Formulas
Range	Formula
C2	=SUMIFS(M:M,L:L,A2,J:J,"cash")