| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumifs criteria
I am trying to sum data using the sumif function =SUMIF($A$1:$A$714,
"=396??.50", $B$1:$B$714) (Criteria range, criteria, sum range) The criteria range isan entire month of hourly timestamps and I am trying to sum a specific time (ie 12:00 pm) for the entire month. I have tried converting all of the dates to the excel number ie 39639.50 etc, but I cannot make the function sum even one day using the wildcard symbols "*" or "?". I have tried many different versions ofthis formula to no avail. please help -A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS formula using dates and text as criteria | Excel Discussion (Misc queries) | |||
| Sumifs - greater than criteria with a Cell Reference | Excel Worksheet Functions | |||
| SUMIFS with 3 criteria instead of just 2 | Excel Worksheet Functions | |||
| using sumifs to sum based on month, and criteria | Excel Worksheet Functions | |||
| Using wildcards in criteria for sumifs functions | Excel Discussion (Misc queries) | |||
Threaded Mode
