Forum Discussion

Brass Contributor

Apr 15, 2024

Solved

Count function need to get single value

Dear Friends, Kindly help me the below issue. (COUNTIFS(Sheet1!N:N,"india",India!J:J,"ibm")) i have a excel with complete Region wise data, if i will give count function if there will be 2 or m...

excel

SergeiBaklan
Apr 15, 2024
SUDHAKAR-FRONTIER

Perhaps

=MIN(1, COUNTIFS(Cus!B:B,B3,Cus!C:C,"infra") )

SUDHAKAR-FRONTIER

Brass Contributor

Apr 15, 2024

Riny_van_Eekelen i have attached the below data. i have highlight the two column its in 2 but i need its only 1 count ..

Test15th Mar.xlsx15 KB

SergeiBaklan

Diamond Contributor

Apr 15, 2024

SUDHAKAR-FRONTIER

Perhaps

=MIN(1, COUNTIFS(Cus!B:B,B3,Cus!C:C,"infra") )

SUDHAKAR-FRONTIER
Brass Contributor
Apr 15, 2024
Thank you Sergei Baklan & Riny now its working
- SergeiBaklan
  Diamond Contributor
  Apr 15, 2024
  SUDHAKAR-FRONTIER , you are welcome