I'm trying to sum values in a spreadsheet for a given personnel number and a given date range. And my formula works if I enter a specific date (ex: =SUMIFS(myte!N2:N29069,myte!D2:D29069,Sheet3!E3,myte!L2:L29069,"=01/06/2012") however when I enter a range I always get zero: =SUMIFS(myte!N2:N29069,myte!D2:D29069,Sheet3!E3,myte!L2:L29069,">=01/01/2012",myte!L2:L29069,"<=01/07/2012"). Any help would be greatly appreciated!!
Hello
See if the following amendment to your formula works.
=SUMIFS(myte!N2:N29069,myte!D2:D29069,Sheet3!E3,myte!L2:L29069,">="&DATE(2012,1,1),myte!L2:L29069,"<="&DATE(2012,1,7))
Last edited by DBY; 02-06-2012 at 02:38 PM. Reason: Entered wrong date
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks