Forum Discussion
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...
SUDHAKAR-FRONTIER The screenshots merely show what you consider to be an incorrect result and one that is correct. But NOT the underlying data. Difficult to diagnose what's wrong.
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 ..
- Thank you Sergei Baklan & Riny now its working
SUDHAKAR-FRONTIER , you are welcome
SUDHAKAR-FRONTIER Don't understand what you are trying to achieve but the formulas do what they should based on the data you provided. In both cases there are two entries (i.e. rows) that fulfill both criteria,