| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum data in column for dates until today
.... SUMPRODUCT should work .. it does for me.
But you have a solution ... "jonnel" wrote: Toppers Wrote: Try: =SUMPRODUCT(--(A1:A366<=Today()),--(B1:B366)) You cannot use "whole" columns with SUMPRODUCT i.e. A:A is not allowed. or =SUMIF(A:A,"<=" & TODAY(),B:B) HTH Hi, The first formula doesn't work (I just copied and pasted it), but the 2nd one absolutely does! So thanks a lot! :) John -- jonnel ------------------------------------------------------------------------ jonnel's Profile: http://www.excelforum.com/member.php...o&userid=36946 View this thread: http://www.excelforum.com/showthread...hreadid=566570 [/color] |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
