LinkBack URL
About LinkBacks
momus12 
Dear momus12,
Can you please tel me what do you want to do,so i can help you
thanks
Dear momus12,
Can you please tel me what do you want to do,
thanks
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Hi Rahul,
I need to calculate the percentage of responses and record them by date. If you look at cell B18 on the spreadsheet I attached, it shows what specifically I'm trying to calculate. (I hope anyway.
Still not sure what you're trying to do, but maybe this. In B18 and copy down and across,
=IF($B$1 <> $A18, "", COUNTIF(A$4:A$9, "Yes") / COUNTA(A4:A9) )
Entia non sunt multiplicanda sine necessitate
if you want the percentage of responses The following formula is perfect
=IF($B$1 <> $A18, "", COUNTIF(A$4:A$9, "Yes") / COUNTA(A4:A9)*100 )
I hope this work for you.
Thanks
Wow! That's exactly what I was trying to do. I understand that $B$1 <> $A18, states that if B1 is not less than or greater than A18 as a condition, but what does "" represent in the formula?
Thanks so much to both of you!
It means return nothing, a null string.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks