|Sorry I posted you the link earlier today with that webpage, where this problem was being discussed.|
Data is as follows:
15 metre-10 min Average: 3.3728 (B13) 2.507302 (B14)
Ans from IF Eqn:
I'm at the point where I have a column full of 1s and 0s from the IF equation, now I want to sum the results to determine if in one calender year I have 2,500 hours of wind speed at > 2.5. When I use the formula =SUM(B13:B16) it returns an answer of 0. As I outlined above the sum formula is working fine elsewhere in the sheet to sum other columns but for this column that I'm interested in it keeps returning a value of 0. I've tried copying and paste special but it didnt work. Instead of summing the entire 52,000 cells, I tried just summing 3 cells but the answer was still incorrect.
As I stated above it will only sum them correctly if i select the cell and use the plus sign and then select the next cell, which isnt an option with the amount of data I have to analyse.
Sorry about the lack of information, I'm a new user to the site. I couldnt find a way around this problem so I had to seek help. Your help is greatly appreciated, I owe you a pint of the blackstuff "Guiness" if you ever visit the emerald isle...