Thread: Timesheet calculations
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Timesheet calculations
Errata, typo corrected, it should be:
=SUM(SUMIF(Sheet1!B:B,A2,Sheet1!C:C),
SUMIF(Sheet1!F:F,A2,Sheet1!G:G),
SUMIF(Sheet1!J:J,A2,Sheet1!K:K),
SUMIF(Sheet1!N:N,A2,Sheet1!O:O))
--
Max
Singapore
---

Reply With QuoteReply With Quote