Excel Forum
Similar Content
SUMIFS - Sum Values Based on Multiple Criteria in Excel
Tutorial: The SUMIFS function allows you to sum values that meet multiple criteria across multiple ...
Wildcards in Excel
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...



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.