i apologize in advance for starting 3 threads in 1 day, but i thought each one was different enough from the last top warrant it's own thread.

here's an example of what i am trying to do. i have 4 worksheets with various names. i have an 5th worksheet with a named list (TabNames) of the 4 worksheet names

each of the 4 worksheets have cells with percentages in them.

i would like to check a cell from each sheet and see if the percentage is equal to or above a certain %, for example anything equal to or above 90%. then return the number of cells that meets or exceeds that 90% criteria.

so for example

sheet1 sheet2 sheet3 sheet4
A
1 80% 91% 76% 82%
2 80% 95% 92% 43%

so checking cell A1 in list TabNames would return 1, and checking cellA2 would return 2.

thanks...last topic today i promise just starting to learn about excel formulas...