Forum Discussion
Solved
Query related to COUNT
Hello Everyone, I tried the formula, but it give me wrong answer. It count all criterias. like - so, I want to count DIVISION column of NORTH, SOUTH, WEST and CATEFORY column of SUPPLIES, ...
Excel I believe like so:
Your set-up was counting ALL 14 rows for East (i.e. not West) plus 1 row for North/Supplies plus 1 row for South/Telemarketing = 16 rows.
Excel I believe like so:
Your set-up was counting ALL 14 rows for East (i.e. not West) plus 1 row for North/Supplies plus 1 row for South/Telemarketing = 16 rows.
Thank you so much sir.