excel Formula - sum only visible cells with multiple criteria

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
Office Version
365
Platform
Windows
That's exactly what the formula you linked to does.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,650
Office Version
365
Platform
Windows
Note that "SUMPRODUCT" was what we used to used to do "SUMIFS" before "SUMIFS" existed!
While SUMIFS exists now, there are still some more complex situations that will require you to use SUMPRODUCT instead.

Basically, any formula that you come up with using COUNTIF, COUNTIFS, SUMIF, or SUMIFS can also be done with SUMPRODUCT.
But SUMPRODUCT is more flexible, and can do more complex calculations.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,370
Messages
5,486,460
Members
407,548
Latest member
FayP

This Week's Hot Topics

Top