Previous Topic Next Topic

Countif function

[Solved/Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 -
Hello,
I'll like to know if i can use the coutif function on multiple values?
for example: =COUNTIF(E2:E30,(AND(G2:G30, "=הסתיים",A2:A30,"=11"),"=true")))

why isn't working on arria when I want to count the maches?
Thanks
Goldi

3 replies

Answer 1 / 3
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 802
try this

=SUMPRODUCT((A2:A30=11)*(G2:G30="=5)*(E2:E30<>0))

assuming there are no zeroes in E2:E30
Answer 2 / 3

Dear venkat1926
Thank you very much,
your answer helpped me a lot.
Wher are you from?
goldi
Answer 3 / 3
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 802
INDIA
Ask a question