Ldonoghue✭✭

Thanks for the shortcut - that worked! I promise to leave you be now!

You know that no good deed goes unpunished, right? :-) I have another one. The following formula works for every variable except "Three Quarter" - which references the progress bar display. Thoughts? I've tested it as the only IF/AND and it does not seem to recognize Three Quarter. Same issue with other progress symbols.…

Aha! I was going to respond that it was outputting numbers but when I looked at my formula I realized it had the numbers inside quotation marks. Removed those and it works - thank you!!

Thank you for your responses and suggestions @Curtis Lange and @Paul Newcome! I continue to run into issues - I think in the case of the INDEX formula, possibly because of the type of data in the column or because it's referencing a different sheet. I think I've found a workaround that will get me what I need, but you…

Thanks! The ranges are all entire columns.

Returns #Incorrect Argument :( Thank you for the syntax corrections nonetheless - it is helpful for me when I'm trying to find missing or misplaced commas, etc!

Thank you jpaul - but that returns #INVALID OPERATION.

Thank you for responding Hollie! That did not work but it leaves out part of the equation. I want to calculate the percentage of records that achieved a certain score in a given period. So I'm saying for this period (e.g. "June"), count all the records scoring ">3" (COUNTIF) and divide that number by the total number of…

Hi and thanks for your response! The typo was just in the example; the syntax is correct in the actual sheet. I think the issue is that "IF" is not the right formula to use. The countif/count part works - it's adding the IF statement that doesn't.

谢谢你,我将与这个实验!