Jun 03 2022 10:43 PM - edited Jun 03 2022 11:44 PM
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, TELEMARKETING
What function should i write?
Please help..??
Here is a attached file
Jun 04 2022 12:28 AM
Solution@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.
Jun 04 2022 12:28 AM
Solution@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.