Sum based on date greater than and a specific status adding to a t
 

Hi,
Trying to create a formula which will check the start date = 01/01/2005 and
then check if a staus = complete and if these are both true then add 3rd
column (which contains a value) to an overall total.

Any help on getting this to work would be appreciated,
Thanks

Sum based on date greater than and a specific status adding to a t
 

=SUMPRODUCT((YEAR(startdate)=2005)*(status="compl ete")*value)
or
=SUMPRODUCT(--(YEAR(startdate)=2005),--(status="complete"),value)
--
David Biddulph

"SusanG" wrote in message
...
Hi,
Trying to create a formula which will check the start date = 01/01/2005
and
then check if a staus = complete and if these are both true then add 3rd
column (which contains a value) to an overall total.

Any help on getting this to work would be appreciated,
Thanks

Sum based on date greater than and a specific status adding to a t
 

In article ,
SusanG wrote:

Hi,
Trying to create a formula which will check the start date = 01/01/2005 and
then check if a staus = complete and if these are both true then add 3rd
column (which contains a value) to an overall total.

Any help on getting this to work would be appreciated,
Thanks


Try...

=SUMPRODUCT(--(DateRange="01/01/2005"+0),--(StatusRange="Complete"),Rang
eToSum)

--
Domenic
http://www.xl-central.com

Sum based on date greater than and a specific status adding to a t
 

Assuming you have date in ColA, Status in Column B and value in ColC.
A1:A100 formated as date

=SUMPRODUCT(--(A1:A100=DATE(2005,1,1)),--(B1:B100="Complete"),--(C1:C100))
--
If this post helps click Yes
---------------
Jacob Skaria


"SusanG" wrote:

Hi,
Trying to create a formula which will check the start date = 01/01/2005 and
then check if a staus = complete and if these are both true then add 3rd
column (which contains a value) to an overall total.

Any help on getting this to work would be appreciated,
Thanks

Sum based on date greater than and a specific status adding to
 

Many thanks, great help.
Susan

"Jacob Skaria" wrote:

Assuming you have date in ColA, Status in Column B and value in ColC.
A1:A100 formated as date

=SUMPRODUCT(--(A1:A100=DATE(2005,1,1)),--(B1:B100="Complete"),--(C1:C100))
--
If this post helps click Yes
---------------
Jacob Skaria


"SusanG" wrote:

Hi,
Trying to create a formula which will check the start date = 01/01/2005 and
then check if a staus = complete and if these are both true then add 3rd
column (which contains a value) to an overall total.

Any help on getting this to work would be appreciated,
Thanks