Previous Topic Next Topic

Countif function

Solved/Closed
goldi - Nov 29, 2009 at 07:49 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 30, 2009 at 10:20 PM
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
Related:

3 responses

Answer 1 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 29, 2009 at 10:11 PM
try this

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

assuming there are no zeroes in E2:E30
0
Answer 2 / 3
goldi
Nov 30, 2009 at 02:44 AM
Dear venkat1926
Thank you very much,
your answer helpped me a lot.
Wher are you from?
goldi
0
Answer 3 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 30, 2009 at 10:20 PM
INDIA
0

Similar discussions

"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response