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 drag so I do not have to rewrite the range each time. Does anyone know how to do this? I have cells with the prewritten ranges I'll want to use. I can give more information if that helps people understand.
1 Reply
Yes, more information would be very helpful. Ideally, you'd make available a copy of the actual workbook. At the very least an image. As the old saying goes, "A picture is worth a thousand words."
