Excel Formula to Discern Text from Numbers

Forewarning, I'm asking for Excel help, but running my spreadsheet in Google Sheets.

I've made a few different macro-enabled sheets where a user does a workout, clicks the "Finish" button, and it logs their results on a separate worksheet tab. I'm trying to expand this to better account people using resistance bands versus weights. The difference in the data would be resistance bands are entered as text where weights would be entered as a number.

The challenge I'm running into is generating an average; I'm trying to get a nested IF formula to do an Average formula for all the cells that have numbers, and a Mode formula for the cells that have text. There's a drop-down that a user would select that would the IF statement would reference for whether to search for numbers or text.

Is this even possible? The two formulas I have are working fine independently, as long as the text and numeric values are segregated. I've Googled and searched StackOverflow for solutions, but I've only found ways to return specific text strings, not determine if a value in a cell is numeric versus text. I'm specifically trying to avoid VBA.

Thanks in advance!