LinkBack URL
About LinkBacks
Hi,
I have the below requirement. I want to get a % of Pass Number in some range.
Cell Adress Value
A1 Pass
B1 Pass
C1 Fail
As per the above i should get 99% as pass%. Pls help in this regard. Can i do with countif formula.
Thanks
Hi,
I have the below requirement. I want to get a % of Pass Number in some range.
Cell Adress Value
A1 Pass
B1 Pass
C1 Fail
As per the above i should get 99% as pass%. Pls help in this regard. Can i do with countif formula.
Thanks
Last edited by Gayucvns; 08-28-2009 at 09:22 AM.
Tr y this
=COUNTIF(range;"pass")/COUNTA(range)
But you get 66%, not 99?
Never use Merged Cells in Excel
Hi
look at the attached file...
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Isn't it 66.7% ?
If you want the number of passes as a percentage of total entries try like this
=COUNTIF(A1:A10,"Pass")/COUNTA(A1:A10)
format result cell as percentage
Yes i got 66.67% only. But i have some dount if we get all pass then we are getting 100%...but i got 1 failed which means i should get 99%....Plesae correct me if im wrong.
I correcting you
You will get that only if you have 100 entries exactly.
=COUNTIF(A1:A100,"Pass")/100
Re: Doubt in CountIf
Hi Zbor,
You are correct...i just understood that...i was bit confused....
Thanks a lot for all the help !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks