# Summing Multiple Columns and Rows

##### New Member
I've generated a worksheet for pari-mutual betting and I've hit a road-block. I added results to range L1:N4. I need a formula in cells M7 and M8 that will search for winning bets and calculate the total payout due to the bettor. This worksheet has many more rows and several more columns. I made the odds 1/1 to simplify.
Can anyone help?

Excel 2016 (Windows) 32 bit
ABCDEFGHIJKLMN
1LAST NAME/FIRST NAMETEAM NUMBERWAGER TYPEAMOUNTTEAM NUMBERWAGER TYPEAMOUNTTEAM NUMBERWAGER TYPEAMOUNTRESULTSTEAM MEMBERODDS
2Ambler, Rosendo23FLIGHT WIN519OVERALL SHOW2534FLIGHT PLACE10OVERALL WIN701/1
3Burgo, Mose66FLIGHT PLACE1041FLIGHT WIN3010FLIGHT SHOW15OVERALL PLACE141/1
4Higham, Herta83FLIGHT SHOW1564FLIGHT PLACE3589OVERALL WIN20OVERALL SHOW381/1
5Elvin, Domingo70OVERALL WIN2024FLIGHT SHOW4014OVERALL PLACE25
6Shiffer, Alene90OVERALL PLACE2520OVERALL WIN4517OVERALL SHOW30BETTORPAYOUT
7Tome, Norberto21OVERALL SHOW3014OVERALL PLACE509FLIGHT WIN35Elvin, Domingo45
8Steveson, Mignon27FLIGHT WIN3538OVERALL SHOW590FLIGHT PLACE40Vrba, Benito40
9Hoehne, Marti66FLIGHT PLACE4062FLIGHT WIN1050FLIGHT SHOW45
10Bingaman, Elba17FLIGHT SHOW454FLIGHT PLACE1571OVERALL WIN50
11Wollard, Kathleen30OVERALL WIN5031FLIGHT SHOW2059OVERALL PLACE5
12Vrba, Benito14OVERALL PLACE570OVERALL WIN2538OVERALL SHOW10
13Taitt, Melissa59OVERALL SHOW1038OVERALL SHOW2546FLIGHT WIN15
14Grasty, Ismael13FLIGHT WIN1587FLIGHT WIN3085FLIGHT PLACE20
15Valenzuela, Tesha5FLIGHT PLACE2035FLIGHT PLACE3586FLIGHT SHOW25
16Cowan, Lennie83FLIGHT SHOW2591FLIGHT SHOW4054OVERALL WIN30
17Sanchez, Janet3OVERALL WIN3044OVERALL WIN4514OVERALL PLACE35
18Griffin, Brian91OVERALL PLACE3595OVERALL PLACE5079OVERALL SHOW40
19Bailey, Keith47OVERALL SHOW4084OVERALL SHOW549FLIGHT WIN45
20Mitchell, Jeremy39FLIGHT WIN4523FLIGHT WIN108FLIGHT PLACE50
21
22

</tbody>
Sheet1

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

#### jtakw

##### Well-known Member
Hi,

Would summing row by row work for you?

K2 formula with your criterion hard-coded.
L2 formula uses cell references for criterion.

Either formula copied down:

Replies
6
Views
73
Replies
4
Views
520
Replies
1
Views
48
Replies
1
Views
53
Replies
23
Views
213

1,109,445
Messages
5,528,800
Members
409,835
Latest member
Mafu1267

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
• Auto-Create a monthly Sign in sheet for preschool students
The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
• VBA vlookup multiple results
Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
• Extract values for earliest/latest times
I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...