|
Featured Tutorial
Featured Macro
Highline Excel Class 09: SUMIF Function Formula 3 Examples
See three examples for SUMIF function:
1)SUMIF where you want to add only a certain Sales Reps Sales and sum_range (third argument is the whole range
2)SUMIF where you want to add only a certain Sales Reps Sales and sum_range (third argument is only the first cell of the sum_range
3)SUMIF function where data base with values to sum are on a different worksheet than the SUMIF function formula
4)
Add conditionally, sum conditionally with criteria, add with 1 criteria
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
1)SUMIF where you want to add only a certain Sales Reps Sales and sum_range (third argument is the whole range
2)SUMIF where you want to add only a certain Sales Reps Sales and sum_range (third argument is only the first cell of the sum_range
3)SUMIF function where data base with values to sum are on a different worksheet than the SUMIF function formula
4)
Add conditionally, sum conditionally with criteria, add with 1 criteria
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109