Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 05 January 2022
  3 Replies
  5.9K 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
 
2 years 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
2 years ago
·
#2429
0
Votes
Undo
Hi Amanda
Many thanks for your answer. Problem solved.

T
2 years ago
·
#2430
0
Votes
Undo
hhhhhhhhhhiiiiiiiiiiiiii
  • Page :
  • 1
There are no replies made for this post yet.