Hello i was wondering if i could get some help with a count if/vlookup forumula.
i was able to figure out total but i couldnt wrap my head around how many times it matches in the DATA column.
Thanks in advance!
Sheet Name = "DETAIL"
<tbody>
</tbody>
Sheet Name = "REPORT"
<tbody>
</tbody>
- Need to look at each direction, first looking at "north" direction in the month of "JAN"
- Then need to look at the "NUMBERS" sheet and see how many times does that number matches the one that is in the DATA Column in DETAIL sheet.
i was able to figure out total but i couldnt wrap my head around how many times it matches in the DATA column.
Code:
=COUNTIFS(DETAIL!C:C,"JAN",DETAIL!A:A,"NORTH")
Sheet Name = "DETAIL"
<tbody> </tbody> | DATA |
<tbody> </tbody> | ||
north | 1 | JAN | ||
north | 2 | JAN | ||
north | 3 | FEB | ||
south | 4 | JAN | ||
east | 5 | MAR | ||
west | 6 | MAR |
<tbody>
</tbody>
Sheet Name = "REPORT"
NUMBERS |
1 |
0 |
1 |
0 |
5 |
FALSE |
0 |
3 |
0 |
<tbody>
</tbody>