formula help

[datadummy]

I am looking for a formula to give me a percent of the following,
(Tab4 column A "Gen Med" - Tab3 column A "Gen Med") / (Tab4 column A "Gen Med")
I keep getting a % that's like 19000% so clearly I'm doing something wrong. I have tried countif(s) and they haven't worked or I am just entering them wrong. I hope this is possible.

 

[Trebor76]

Hi there,

Try this:

=(COUNTIF('Tab4'!A:A,"Gen Med")-COUNTIF('Tab3'!A:A,"Gen Med"))/COUNTIF('Tab4'!A:A,"Gen Med")

Just format whatever cell you have the formula in as a percentage.

HTH

Robert

 

[datadummy]

Hi Robert,
I tried that and got an error message, so I removed the second parenthesis after the second countif statement and then it worked but the result was 19398%.

 

[Trebor76]

I tried that and got an error message

That's odd - it worked for me

the result was 19398%

Without having your data I can't comment. Perhaps doing the sum manually will show you what's happening.

Robert

 

[datadummy]

I double checked what I entered and it appears I didn't add the parenthesis before the equal sign, I reentered it and now it appears to be working, thanks for the help!!

 

[Trebor76]

Sounds like the mathematical precedent order got mixed up. I'm glad we got it sorted in the end