How to determine Ratio/Percentage

  • Thread starter Thread starter NoNoBadDog!
  • Start date Start date
N

NoNoBadDog!

I have several retail stores that I must visit, and at the conclusion of
each visit I must complete and submit a form that summarizes my visit. If I
visit a store that has wireless access, I can file the report immediately
using my PDA. If the store does not have wireless access, I must wait until
I am back in my office to file the report via the web. I keep track of my
visits using an Excel worksheet, and I have a column where I keep track of
how the report was files (WEB or PDA). I have a new worksheet for each
month.

What formula can I use to give me either a ratio of reports files via PDA
vs. Web, or a percentage(i..e 70% PDA, 30% WEB). Since I track the
reporting method in a single column, I am hoping there is an elegant and
simple way to do this.

I look forward to any responses.

Thanks!

Bobby
 
Hi
if your values are in column A try
=COUNTIF(A:A,"PDA")/COUNTA(A:A)
and format this cell as percentage
 
Frank,

But what if he wants to report on the percentage for the whole year (meaning
across each of the monthly spreadsheets). Your solution works fine for one
month, but when I enter
=COUNTIF(Sheet2:Sheet3!A:A,"PDA")
I get the #VALUE! result. Doesn't COUNTIF work across multiple sheets? Is
there an easy alternative to get the same answer? I'm stumped on that one.

Thanks.
 
Back
Top