Hello everyone!
I have a table that can have different number of rows whenever I update the data. What I need is to get a formula that can accommodate all available rows, i.e. today's file has 1000 rows vs. last week was 998 and maybe tomorrow is 1001. Another component of the formula is I need to add multiple criteria to my current countif clause.
I was trying to paste the table here but has issues. Here's a sample of the table and my current formula:
Formula: =COUNTIF($C$3:$C$28,F3)
I need to add another criteria to the current formula to count Type 1 and 3 for date 11/29/2023. Any suggestions?
I have a table that can have different number of rows whenever I update the data. What I need is to get a formula that can accommodate all available rows, i.e. today's file has 1000 rows vs. last week was 998 and maybe tomorrow is 1001. Another component of the formula is I need to add multiple criteria to my current countif clause.
I was trying to paste the table here but has issues. Here's a sample of the table and my current formula:
Formula: =COUNTIF($C$3:$C$28,F3)
I need to add another criteria to the current formula to count Type 1 and 3 for date 11/29/2023. Any suggestions?
Name | ID | Date | Type |
A | 30032 | 11/29/2023 | 1 |
B | 60903 | 11/28/2023 | 1 |
C | 93394 | 11/29/2023 | 2 |
D | 76295 | 11/29/2023 | 2 |
E | 79646 | 11/29/2023 | 1 |
F | 63724 | 11/29/2023 | 1 |
G | 63269 | 11/29/2023 | 2 |
H | 97051 | 11/29/2023 | 2 |
I | 79824 | 11/27/2023 | 1 |
J | 39850 | 11/29/2023 | 2 |
K | 79080 | 11/29/2023 | 1 |
L | 88087 | 11/29/2023 | 3 |
M | 35162 | 11/29/2023 | 2 |
N | 54564 | 11/29/2023 | 3 |
O | 37087 | 11/29/2023 | 2 |
P | 92487 | 11/26/2023 | 1 |
Q | 21703 | 11/29/2023 | 2 |
R | 20914 | 11/29/2023 | 2 |
S | 87354 | 11/29/2023 | 1 |
T | 76313 | 11/25/2023 | 2 |
U | 52217 | 11/29/2023 | 1 |
V | 28653 | 11/29/2023 | 2 |
W | 15879 | 11/18/2023 | 2 |
X | 88872 | 11/29/2023 | 1 |
Y | 30988 | 11/29/2023 | 1 |
Z | 14774 | 10/31/2023 | 2 |
