Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help - Conditional Sums
Forgive me if "Conditional Sums" is not the accurate word for what I am
trying to accomplish... I'm at a loss for what to call this situation. What I have is a spreadsheet totaling attendance figures for classes taught by two people (Dave and Cary). Column A lists their name, and next to it in Column B is the number of people who attended that class. What I need is a formula that will look at the sheet and report in a given cell the total for attendance for each person. I can work basic formulas like SUM, but that will give the total for the entire column, when what I need it to do is only add the numbers in Column B that have the word "Dave" directly next to them in Column A. And then repeat for "Cary". Can anyone give me some advice on this? Thank you! -Dave B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional sums | Excel Worksheet Functions | |||
Conditional sums - counting unique | Excel Discussion (Misc queries) | |||
conditional sums and multiple criteria | New Users to Excel | |||
Conditional Sums | New Users to Excel | |||
Conditional sums for adjacent cells | Excel Worksheet Functions |