ExcelBanter - SUMIF question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF question (https://www.excelbanter.com/excel-worksheet-functions/240800-sumif-question.html)

RedDixieCup

SUMIF question

I have two colums of data, the first is a time/date stamp in mm/dd/yyyy hh:mm
format, the second is a rainfall amount (0.00).

I need a daily total for the rainfall for about 5 years worth of data.

Halpz!

Jacob Skaria

SUMIF question

Query date in cell d1
=SUMPRODUCT(--(TEXT(A1:A100,"mmddyyyy")=TEXT(D1,"mmddyyyy")),B1: B100)

If this post helps click Yes
---------------
Jacob Skaria

"RedDixieCup" wrote:

I have two colums of data, the first is a time/date stamp in mm/dd/yyyy hh:mm
format, the second is a rainfall amount (0.00).

I need a daily total for the rainfall for about 5 years worth of data.

Halpz!

Jacob Skaria

SUMIF question

Try with date and time in Col A and rainfall amount in Col B

=SUMPRODUCT(--(TEXT(A1:A100,"mmddyyyy")="08272009"),B1:B100)

If this post helps click Yes
---------------
Jacob Skaria

"RedDixieCup" wrote:

I have two colums of data, the first is a time/date stamp in mm/dd/yyyy hh:mm
format, the second is a rainfall amount (0.00).

I need a daily total for the rainfall for about 5 years worth of data.

Halpz!

All times are GMT +1. The time now is 08:47 AM.