Is there a way to produce a sum according to date time stamp values of another column on excel

0 votes

I have a CSV file of rain gauge data, with the following example format:

No.    Date/time.           Rainfall
1.     01/21/22 03:13:56    0
2.     01/21/22 03:14:56    0
3.     01/21/22 03:15:56    2.1
4.     01/21/22 03:16:56    1.4
...

Is there a way for me to resample this data to produce a daily sum? A formula perhaps?

Mar 25, 2023 in Others by Kithuzzz
• 38,010 points
353 views

1 answer to this question.

0 votes

Assuming the input data for the second column is in date format, you can use the following formula if you prefer it to a Pivot Table:

=LET(B, INT(B2:B7), C, C2:C7, ux, UNIQUE(B), 
 m, MAP(ux, LAMBDA(x, SUM((B=x) * C))), VSTACK({"Days","Total"}, HSTACK(ux, m)))

Here is the output. output

answered Mar 25, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Is there a function in excel to automatically calculate age using date of birth?

Try  =INT((YEARFRAC(TODAY(),B3,1)))  Where cell B3 contains a date like ...READ MORE

answered Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
286 views
0 votes
1 answer

Is there a way to generate high resolution PNGs of iOS emoji?

Step 1: Visit Google Play Store on ...READ MORE

answered Nov 4, 2022 in Others by gaurav
• 23,260 points
291 views
0 votes
1 answer

Group by Sum in Excel

It is very easy and you can ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
400 views
0 votes
1 answer

Getting SUM for hh:mm:ss in EXCEL

The times are probably preserved as text. SUM ...READ MORE

answered Oct 23, 2022 in Others by narikkadan
• 63,420 points
5,491 views
0 votes
1 answer

Excel sum formula without table - Equivalent to the Math Sum Symbol

You can use SUMPRODUCT for this. Assuming X is in cell B1, ...READ MORE

answered Dec 11, 2022 in Others by narikkadan
• 63,420 points
269 views
0 votes
1 answer

How to sum the value of 2 rows with vlookup by only using 1 formula?

 Try in Excel Online: • Formula used in cell C3 =SUM(SCAN(0,M3:N3,LAMBDA(x,y,VLOOKUP(y,P3:Q12,2,0)))) Works ...READ MORE

answered Jan 17, 2023 in Others by narikkadan
• 63,420 points
277 views
0 votes
1 answer

Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,420 points
1,489 views
0 votes
1 answer

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,420 points
836 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP