Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 05 January 2022
  2 Replies
  2.4K Visits
0
Votes
Undo
Column A lists electricity usage for each half hour period. Columns B and C list half hour time periods per twenty four hours. Columns D and E list the actual half hours. Because the usage tariff is split I would like to be able to add the usage figures for the times between 00.30 and 04.30. I extracted the data in columns D and E using "TIMEVALUE". I have tried to do the addition by using "SUMIFS" but have failed miserably. Is this a process that I could do using my copy of Kutools and if so how please?
I have attached a 24 hours copy spreadsheet.

Many thanks

Tim Walls
 
8 months ago
·
#2428
0
Votes
Undo
Hi Tim,

To sum all the usage figures for the times between 00.30 and 04.30, please use the formula: =SUMIFS(A2:A49,D2:D49,">=0:30",D2:D49,"<4:30")

Please check the operators in the formula to suit your needs.

Amanda
8 months ago
·
#2429
0
Votes
Undo
Hi Amanda
Many thanks for your answer. Problem solved.

T
  • Page :
  • 1
There are no replies made for this post yet.