Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with more than 1 criteria
i have a table with months in column B and names in column a and % scores in
column c. i want to create a formula that states if column B="nov" and column A = "Bill" then total column c for those rows. actuly i want an average score for bill for the month but i think i need to do that as a sepearate formula once i have the total. name date score bill nov 98% tony nov 95% Bill Nov 85% Bill dec 85% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with more than one criteria | Excel Discussion (Misc queries) | |||
SUMIF with two criteria | Excel Discussion (Misc queries) | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF with more than 1 criteria | Excel Worksheet Functions | |||
sumif 2 criteria | Excel Worksheet Functions |