Forum Discussion
output a sum for variable precise limit
Dear All Not sure if this can be done, but if someone has an idea, it would be very helpful. I have downloaded a years data from temperature probe into excel, what i want to do is find a total t...
You have define the set of rows with unique identifier in next column "F" such as number 1,2,3... So for ex. Row 54-172 can be tagged as 1 and then 200-214 as 2 and so on.
After this use COUNTIFS($E$1:$E$576,">25",$F$1:$F$576,1)
Same thing can be used for another set of rows having tag as 2 and so on. Make sure range is selected overall on all rows.