Modifying range inside a formula

[Tripp]

Hello,

I have to display the amount of water flowing over a period of time and to make it easier to compare I would like to sum the amount of water to every month.

The time stamps are in the format "dd/mm/yyyy 00:00" and I want to convert it to month as a single number which I can do in a separate column but I'm trying to do inside the formula with something like this:

=SUMIFS(Water measurements, month(time stamps of measurements), month number)

I'm aiming for a table with the total water measured for each month but I cant solve it without a cheater column.

I have uploaded a sample to help explain my task

Regards,

Tripp

 

[Chihiro]

Pivot Table is your friend.

Or you can use...
=SUMPRODUCT(--(MONTH(A2:A11)=F2),B2:B11)

But don't be afraid to use Helper Column.
Often times, there's less overhead when helper column is used.
And it makes following formula logic so much easier for someone else that inherits your workbook.