Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum If and Count If
Is there a way to use sumif and count if if your criteria is dates? In my
spredsheet column A are dates. My spreadsheet looks like this. A B C D Date Loc. Stops $ 11/17/09 Miami 2 $1150 11/18/09 Orlando 1 $1000 I have tried =SUMIF(A3:A5,11/17/9,D3:D51). I have also tried converting column A to show 2009 instead of 09, but I still get 0 as the result for both. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum If and Count If
Hi TB,
Try: =SUMIF(A3:A5;Date(2009;11;17);D3:D5) HTH, Wouter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum If and Count If
Sorry, I have a different International setting. Ik should be: =SUMIF(A3:A5, DATE(2009, 11, 17), D3:D5) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Excel Count characters in a textbox to display character count? | Excel Programming | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |