| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date criteria with SUMIF or SUMPRODUCT
Below is what I have
A B Date Total ------ ------- Oct-2005 50 Nov-2005 79.3 Dec-2005 76.4 Jan-2006 81 Feb-2006 46.5 Mar-2006 73.6 Apr-2006 106 Oct-2005 150 I am trying to sum up the total column by a certain date criteria from Column A. Below is what I have and it is giving me an error. =Sumif(A2:A8 = Oct-2005, B2:B8) For some reason this formula is not working. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date criteria with SUMIF or SUMPRODUCT
Your syntax is wrong for sumif. try this:
=Sumif(A2:A8,"=Oct-2005", B2:B8) Addy wrote: Below is what I have A B Date Total ------ ------- Oct-2005 50 Nov-2005 79.3 Dec-2005 76.4 Jan-2006 81 Feb-2006 46.5 Mar-2006 73.6 Apr-2006 106 Oct-2005 150 I am trying to sum up the total column by a certain date criteria from Column A. Below is what I have and it is giving me an error. =Sumif(A2:A8 = Oct-2005, B2:B8) For some reason this formula is not working. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date criteria with SUMIF or SUMPRODUCT
=SUMPRODUCT(--(MONTH(A2:A8)=10,--(YEAR(A2:A8)=2005),B2:B8)
"Addy" wrote in message oups.com... Below is what I have A B Date Total ------ ------- Oct-2005 50 Nov-2005 79.3 Dec-2005 76.4 Jan-2006 81 Feb-2006 46.5 Mar-2006 73.6 Apr-2006 106 Oct-2005 150 I am trying to sum up the total column by a certain date criteria from Column A. Below is what I have and it is giving me an error. =Sumif(A2:A8 = Oct-2005, B2:B8) For some reason this formula is not working. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date criteria with SUMIF or SUMPRODUCT
Typo Bob
=SUMPRODUCT(--(MONTH(A2:A8)=10),--(YEAR(A2:A8)=2005),B2:B8) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Bob Umlas" wrote in message ... =SUMPRODUCT(--(MONTH(A2:A8)=10,--(YEAR(A2:A8)=2005),B2:B8) "Addy" wrote in message oups.com... Below is what I have A B Date Total ------ ------- Oct-2005 50 Nov-2005 79.3 Dec-2005 76.4 Jan-2006 81 Feb-2006 46.5 Mar-2006 73.6 Apr-2006 106 Oct-2005 150 I am trying to sum up the total column by a certain date criteria from Column A. Below is what I have and it is giving me an error. =Sumif(A2:A8 = Oct-2005, B2:B8) For some reason this formula is not working. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Awkward sumif/sumproduct with three criteria over two ranges | Excel Worksheet Functions | |||
| SUMIF/SUMPRODUCT Criteria are Variable Sized | Excel Discussion (Misc queries) | |||
| Sumproduct (Sumif) with Nested Or Criteria | Excel Worksheet Functions | |||
| SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text | Excel Discussion (Misc queries) | |||
| sumif or sumproduct with date as criteria | Excel Programming | |||
Linear Mode
