This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello, please show me how to use the SUBTOTAL function with the COUNTIF function....
Let's say I filter columns B-E to show only the dates from 2022.
What formula can I use to display how many times the letter "S" occurs in columns F-G in the filtered list only (not from all the dates)
What formula can I use to display how many times the letter "L" occurs in columns H-I in the filtered list only (not from all the dates)
What formula can I use to display the sum of the numbers in columns L-M in the filtered list only (not from all the dates)
Thanks for your help
Matthew Miller
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
With all due respect, none of that is accurate. You can't even enter those formulas and, if you could, they would not do what you describe.
What would be the way to do this without adding additional columns?