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 in Others 253 views

## 1 answer to this question.

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. • 63,180 points

## Best way to get average values within a specific set of time(say, date or year) using MySQL or Rails

I don't think post-process is what you ...READ MORE

## 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

## Group by Sum in Excel

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

## Getting SUM for hh:mm:ss in EXCEL

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

## 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

## 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