Thread: Adding entries if date entered in another column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Adding entries if date entered in another column
You're welcome, Jen - thanks for feeding back.

Pete

On Feb 17, 5:23*pm, Jen wrote:
Thanks!
I had it close but I was missing the <
=SUMIF(D:D,"<",C:C)
I could not use the "active", because some of them are not in active status,
even though they have a start date.
Thanks for all your help.


Reply With QuoteReply With Quote