| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif + right question | Excel Worksheet Functions | |||
| SUMIF Question | New Users to Excel | |||
| Help Please SUMIF question | Excel Discussion (Misc queries) | |||
| HELP!! SUMIF QUESTION | Excel Worksheet Functions | |||
| SUMIF question | Excel Worksheet Functions | |||
Linear Mode
