SUMIF question

R

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!
 
J

Jacob Skaria

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

If this post helps click Yes
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM IF question (daily rainfall totals) 9
use sumif / Sumproduct for year data 4
conditional if statement 1
SUMIF etc for dates & data 1
date and time difference 19
Date and Time Conversion 3
Summarising date-based data 1
Date format problems after csv import 2

Top