SUMIF question

  • Thread starter Thread starter RedDixieCup
  • Start date Start date
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!
 
Query date in cell d1
=SUMPRODUCT(--(TEXT(A1:A100,"mmddyyyy")=TEXT(D1,"mmddyyyy")),B1:B100)

If this post helps click Yes
 
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
Adding A1:A7, then A8:A14 0
SUMIF etc for dates & data 1
date and time difference 19
Date and Time Conversion 3
Summarising date-based data 1

Back
Top