if is error then "No Data", if not then average range

S

SK08

I believe the formula should be something like:
iferror(average(C1:F1=TRUE,"No Data), average(C1:F1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with IF Function for times. 5
Cell data entering slow! 0
Trying to find additional ranges outside of min, max, and average 2
Spurious Formula Omits Adjacent Cells 2
Calculate average in intervals 1
averaging multiple items from one list 2
VBA multiple list of values for variable 1
Conditional Formatting Formula 3

Top