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
[TABLE="width: 3592"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>[TR]
[TD]Lab Job#[/TD]
[TD]Client Job #[/TD]
[TD]Date & Time Received[/TD]
[TD]Date Sampled[/TD]
[TD]TAT[/TD]
[TD]Lab ID #[/TD]
[TD]Client ID #[/TD]
[TD]Due Date & Time[/TD]
[TD]Sample Retention[/TD]
[TD]Date Analyzed[/TD]
[TD]Date Reported[/TD]
[TD]Prepped By [/TD]
[TD]Reported By[/TD]
[TD]OT[/TD]
[TD]Rush[/TD]
[TD]=COUNTIF(E:E, "=0")[/TD]
[TD]24hr[/TD]
[TD]=COUNTIF(E:E, "=1")[/TD]
[TD]48hr[/TD]
[TD]=COUNTIF(E:E, "=2")[/TD]
[TD]OT[/TD]
[TD]=SUM(N:N)[/TD]
[/TR]
[TR]
[TD]14-3[/TD]
[TD]14-147[/TD]
[TD]41857.6493055556[/TD]
[TD]41857[/TD]
[TD]0[/TD]
[TD]1400013[/TD]
[TD]500[/TD]
[TD]=C2+E2[/TD]
[TD]=H2+60[/TD]
[TD]41857[/TD]
[TD]41857[/TD]
[TD]RB[/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks, my current formulas listed below
[TABLE="width: 3592"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>[TR]
[TD]Lab Job#[/TD]
[TD]Client Job #[/TD]
[TD]Date & Time Received[/TD]
[TD]Date Sampled[/TD]
[TD]TAT[/TD]
[TD]Lab ID #[/TD]
[TD]Client ID #[/TD]
[TD]Due Date & Time[/TD]
[TD]Sample Retention[/TD]
[TD]Date Analyzed[/TD]
[TD]Date Reported[/TD]
[TD]Prepped By [/TD]
[TD]Reported By[/TD]
[TD]OT[/TD]
[TD]Rush[/TD]
[TD]=COUNTIF(E:E, "=0")[/TD]
[TD]24hr[/TD]
[TD]=COUNTIF(E:E, "=1")[/TD]
[TD]48hr[/TD]
[TD]=COUNTIF(E:E, "=2")[/TD]
[TD]OT[/TD]
[TD]=SUM(N:N)[/TD]
[/TR]
[TR]
[TD]14-3[/TD]
[TD]14-147[/TD]
[TD]41857.6493055556[/TD]
[TD]41857[/TD]
[TD]0[/TD]
[TD]1400013[/TD]
[TD]500[/TD]
[TD]=C2+E2[/TD]
[TD]=H2+60[/TD]
[TD]41857[/TD]
[TD]41857[/TD]
[TD]RB[/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: