discrepancy between Excel and Google spreadsheet import

I imported a spreadsheet into a Google Spreadsheet which looks pretty much the same with a few minor fixes needed. I have a cell that is showing the percentage of a number of occurrences of certain variables. In my Excel sheet the percentage is showing correctly: 31%. In the Google spreadsheet, with the same exact information and formula, the cell is showing 25%. Anyone know why this might be?

Thanks
Bryan

Yes. Checked all data and formulas. They are identical. The changes made were more cosmetic than data driven

I went opened a spreadsheet in Google and imported the Excel spreadsheet as a new Google sheet

Well... here's a screen shot. The cell on the right that has the 25% has this formula, adding up cells in column E that have "pro" or "adv" out of the cells with data, ignoring cells with no data The % should be 31% as it is in my Excel doc. This shot is from Google.

=SUM(COUNTIF(E7:E60,"*"&{"Pro","Adv"}&"*"))/COUNTIF(E7:E60,"?*")

screenshot.png

If you tell me what to try I can do so and let you know if it works. The actual file has student names that can't be shared.

Yes they could, but then I would have to change them back. If someone has an idea of how to fix the problem, I am capable of trying the suggestion out to see what the result might be. Anyone willing to to at least tell me what they think the problem could be and what I can try to fix it? Is it possible that the Google spreadsheet needs the formula in a slightly different configuration or language to make it work?

Here is a copy of the Google spreadsheet. You'll notice that in Column E there are 48 entries, 15 being "Pro" and "Adv". This should be a percentage of 31% in cell J8. The formula that is applied to J8 is identical to the one I have on my corresponding Excel spreadsheet, which does show the value of 31%. You'll notice there are extra empty cells at the end of the data. That is in case students come in during the year. I want those cells there, part of J8 formula, but not included in the result if they are empty. Does any of this make sense? I just don't know why it won't work correctly in Google.

https://docs.google.com/a/wausauscho...kNHRzNkE#gid=0

I see an issue is that the formula is only counting the word that shows first in the formula. I just put "Adv" before "Pro" in the formula and now it is only giving me the percentage that "Adv" occurs. There needs to be a way to have the formula recognize "Adv" and "Pro"