Thread: Sum based on date greater than and a specific status adding to a t
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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



Reply With QuoteReply With Quote