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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help - Conditional Sums
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help - Conditional Sums
Take a look at SUMIF() in XL Help.
In article , Dave B wrote: 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help - Conditional Sums
Hi Dave
Maybe something like this : =SUMIF(A15:A30,"dave",B15:B30) adjust range to your needs. "Dave B" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help - Conditional Sums
I suggest you try subtotals, as the total number of people by the teacher
would appear under each column for both Dave and Carry separately Data subtotals -- Thanks Suleman Peerzade "Dave B" wrote: 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help - Conditional Sums
Another way is a pivot table. Drag th column title that contains thier names
into either the row or column section of the pivot table layout and the column title that contains the attendance figures into the data area. Then as the data changes or is added to you can change the range area if needed to include the new rows, or refresh if only the numbers change in the same range. You will love pivot tables...give it a try. "Dave B" wrote: 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 |
Reply |
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 |