Forum Discussion
Using COUNTIF(S) or SUMIF(S)-functions with SUBTOTAL-function
Hey! I keep a record of the training of athletes in Excel. The same view has a table for attendance and event data and an athlete-specific summary where I use the COUNTIF and SUMIF functions Fo...
can you show us a sample of what you mean? as in tables if you filter, your sums & results will filter also
chahine There in a screenshot.
Unfortunately, it is in Finnish. At the top is a summary table of reasons for absences, next is an athlete-specific summary and at the bottom is event data.
Reasons for absences are calculated with the "countif" function and do not follow event data filtering.
black cells are the names of the athletes