Excel Forum



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





Got a Question? Ask it Here in the Forum.