The formula in G5 performs a conditional sum based on the current dropdown selection in F5.
If F5 is any value except “all” (i.e.
Criteria can be applied to dates, numbers, and text.
for partial matching….
SUM Function
The Excel SUM function returns the sum of values supplied.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
More than one condition can be tested by nesting IF functions.
