SOLVED

Query related to COUNT

Super Contributor

Hello Everyone, 

I tried the formula, but it give me wrong answer. It count all criterias.

like - 

Annotation 2022-06-04 111031.png

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

 

 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Zan I believe like so:

Riny_van_Eekelen_1-1654327691165.png

 

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.