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...
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."
So here is my dilemma. The "6" "33" "38" etc will remain the same across the row from 013(1st) to 079 (1st) BUT the range changes each time. I've written the range I want my countif function to reference so if there's a way to insert it I can just drag the equation across keeping the criteria the same while changing the range's to fit my needs.