| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Index to determine total of values
Bob 1
Bob 3 Jill 2 Jill 1 How do I get excel to calculate the total value for Bob and Jill. I have tried index, but cannot get the formula correct. |
|
#2
|
|||
|
|||
|
=SUMIF(A1:A20,"Bob",B1:B20)
-- HTH RP (remove nothere from the email address if mailing direct) "Brian" wrote in message ... Bob 1 Bob 3 Jill 2 Jill 1 How do I get excel to calculate the total value for Bob and Jill. I have tried index, but cannot get the formula correct. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| If column A and column B have values how do i get the total in co. | Excel Discussion (Misc queries) | |||
| subtotalling with summary values above | Excel Discussion (Misc queries) | |||
| Variable values in Index function | Excel Worksheet Functions | |||
| index to a range of cells | Excel Worksheet Functions | |||
Hybrid Mode
