Thread: trying to sum range in one sheet depending on the date in cell on other sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default trying to sum range in one sheet depending on the date in cell on other sheet
Hi,
Am Wed, 23 Sep 2015 09:47:39 +0100 schrieb tomtic56:

COL A COL B COL C
Day Date Hours worked
Friday 03/04/2015 3.5
Monday 06/04/2015 0
Monday 04/05/2015 3.5
Monday 28/09/2015 0
Friday 25/12/2015 3.5
Monday 28/12/2015 0
Friday 01/01/2016 3.5
Monday 04/01/2016 0

try in "public holiday"
=SUMIF('entitlement calculation'!B:B,"="&B12,'entitlement calculation'!C:C)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote