| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF using Dates
Hi,
I want to be able to do a SUMIF where the criteria is that the values should be less than a date (stored in column A). Although I can get the SUMIF expression to work if a explicitly insert the date (e.g. SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g. SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for 04/09/06 - it produces the wrong result. Can anyone point out where I am going wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF using Dates
=SUMIF(...,"<"&A95+7,...)
HTH -- AP "Mike McLellan" a écrit dans le message de news: ... Hi, I want to be able to do a SUMIF where the criteria is that the values should be less than a date (stored in column A). Although I can get the SUMIF expression to work if a explicitly insert the date (e.g. SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g. SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for 04/09/06 - it produces the wrong result. Can anyone point out where I am going wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF using Dates
"Mike McLellan" wrote... Hi, I want to be able to do a SUMIF where the criteria is that the values should be less than a date (stored in column A). Although I can get the SUMIF expression to work if a explicitly insert the date (e.g. SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g. SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for 04/09/06 - it produces the wrong result. Can anyone point out where I am going wrong? Hi! Try it like this: SUMIF(.....,"<"&A95+7,.....) Biff |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF using Dates
Mike,
=SUMIF(......,"<" & A95+7,....) HTH "Mike McLellan" wrote: Hi, I want to be able to do a SUMIF where the criteria is that the values should be less than a date (stored in column A). Although I can get the SUMIF expression to work if a explicitly insert the date (e.g. SUMIF(.....,"<11/09/06",.....), if I insert and expression (e.g. SUMIF(.....,"<(A95+7)",.....) - where A95 contains the date value for 04/09/06 - it produces the wrong result. Can anyone point out where I am going wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of data between two dates - tried SUMIF and it returned "0" | Excel Worksheet Functions | |||
| SUMIF for Dates / Months ? | Excel Worksheet Functions | |||
| SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
| SUMIF USING DATES | Excel Discussion (Misc queries) | |||
| SUMIF between dates | Excel Worksheet Functions | |||
Linear Mode
