Forum Discussion
drag down the text in criteria along with cell range while using countifs
Risk of Injury Nov-21 Dec-21 problem Slip and Trip 2 0 =COUNTIF(SO!$E$769:$E$793,"Slip and Trip") Cut injury 3 6 =COUNTIF(SO!$E$769:$E$793,"Cut injury") Housekeeping 0 0 ...
Mukesh8734 Rather than including the part "Slip and Trip", use a reference to the cell (without $ signs) that contains that phrase. The formula could then look like:
=COUNTIF(SO!$E$769:$E$793,A2)
Copy it down and A2 will change to A3 and so on.
- Thanks a lot sir, you make my work very easy ad it saves 2 hours for me.
Thank you once again
