Forum Discussion
Countif/Countifs
I'm trying to do a standard countifs formula for several columns of information. Each column is using the same criteria but has different ranges. I'm trying to make an equation that will be easy to d...
This does not appear to be working. I get this on my screen. I apologize if I'm doing something incorrect. I do always want countif+countif. Unfortunately, sometimes my ranges will be in the center of a count and may not have empty space above it. Hopefully that won't change anything.
Sorry for the late reply. It seems that either i didn't receive a notification of your reply on Oct 06, 2025 or i was missing something. Please use the formula provided by djclements​ that is perfect for your task. I wasn't aware that this is possible. Attached is my sample file with both formulas however mine is redundant.