How to extract daily data from hourly data

[riddlessaffa]

Hi all,

This is my first post so any help and advice will be appreciated. I have months of hourly data in column A with corresponding consumption (kWh) in column B and what I need to know is how many days there was no consumption? so in the attached example I should have a count of 1 as there was one day with consumption and one day wothout any consumption. Hope that makes sense. TIA

[Glenn Kennedy]

Does this help??

=IF(COUNTIF(A:A,E2)=0,"",IF(SUMPRODUCT((INT($A$2:$A$49)=E2)*($B$2:$B$49))=0,"No consumption","Consumption"))

it's then easy to use aformula to count the "No Consumption" days.

=COUNTIF(G:G,"No Consumption")

[riddlessaffa]

Thanks Glenn. That will work Much appreciated.

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.