I am trying to count data that meets filtered criteria and does't count hidden cells. I use this for tracking sample turn around times. I offer turn around times of 0, 1, and 2 (rush analysis, 1 day analysis, 2 day analysis). When I filter data such as date analyzed, the resultant count still includes hidden cell turn around times. I have looked at other posts and cannot get the formula to work, any help would be greatly appreciated.
Thanks, my current formulas listed below
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>
Thanks, my current formulas listed below
Lab Job# | Client Job # | Date & Time Received | Date Sampled | TAT | Lab ID # | Client ID # | Due Date & Time | Sample Retention | Date Analyzed | Date Reported | Prepped By | Reported By | OT | Rush | =COUNTIF(E:E, "=0") | 24hr | =COUNTIF(E:E, "=1") | 48hr | =COUNTIF(E:E, "=2") | OT | =SUM(N:N) |
14-3 | 14-147 | 41857.6493055556 | 41857 | 0 | 1400013 | 500 | =C2+E2 | =H2+60 | 41857 | 41857 | RB | RB |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>
Last edited: