Thread: Sum based on date greater than and a specific status adding to a t
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic[_2_] Domenic[_2_] is offline
external usenet poster
  
Posts: 265
Default 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
Reply With QuoteReply With Quote