Ask Your Question
0

How to count TRUE entries of other sheet? [closed]

asked 2013-10-30 12:11:28 +0200

Sudhir gravatar image

I would like to count TRUE, if suppose I have Pass/Fail(Has a list) entries in other sheet. I tried to use, but I was not successful. Can someone to put some light on the same?

=COUNTIF('Administration':E3:E100,'Pass')

The above function I am using to retrieve "Pass values" from Administration sheet from E3 to E100 rows


Sudhir

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-12 15:45:30.126537

3 Answers

Sort by » oldest newest most voted
0

answered 2013-10-30 12:25:03 +0200

B.Horvat gravatar image

updated 2013-10-30 12:30:26 +0200

=COUNTIF('Administration'.E3:E100;'Pass') - semicolon, not comma and dot after sheet name.

edit flag offensive delete link more
0

answered 2013-10-31 00:54:52 +0200

m.a.riosv gravatar image

As B.Horvat expose, semicolon is needed as separator, but depends on you locale settings.
Also the text condition must go with double quotes, and single quotes on the sheet name is no needed if there are not spaces.
=COUNTIF(Administration.E3:E100;"Pass")

edit flag offensive delete link more

Comments

Thanks for correction, single quotes in text condition I not saw and single quotes in sheet name I left, they don't make error.

B.Horvat gravatar imageB.Horvat ( 2013-10-31 08:12:02 +0200 )edit
0

answered 2013-10-31 10:42:32 +0200

Sudhir gravatar image

Thank you Guys!! It works!!

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-10-30 12:11:28 +0200

Seen: 270 times

Last updated: Oct 31 '13