SUMIF question

[RedDixieCup]

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]

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

If this post helps click Yes

 

[Jacob Skaria]

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