Averages

How would I find the average temperature reported by node 6 in this case?

Screen Shot 2014-05-15 at 9.02.01 PM.png

Thanks jazzer,

I would rather not include the excel file because I want to figure this out for myself. The spreadsheet has many other components to it and it's a class assignment.

-CGS

Originally Posted by 6StringJazzer

Formula:

Please Login or Register  to view this content.

Also, an image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

I get an error in value message #value! with this function. Any ideas?

I tested that formula by mocking up a spreadsheet based on your screenshot, and it works.

I have no idea why you are getting a #VALUE error without having your file.