Hi,
I am attaching an excel sheet in which I need values from column E and for a specific period. I Have applied date range but its not working properly, can any one help me here.
Hi,
I am attaching an excel sheet in which I need values from column E and for a specific period. I Have applied date range but its not working properly, can any one help me here.
Try
=SUMIFS($E$4:$E$98,$D$4:$D$98,G5,$C$4:$C$98,">=01/07/2012",$C$4:$C$98,"<=30/06/2013")
Data in your formula was formatted as mm/dd/yyyy rather than dd/mm/yyyy
Thanks......
i'm in UK and the dates default to UK values
so I had to change the
6/30/2013
to
30/6/2013
and it worked
do you have the dates defaulted to
MM/DD/YYYYformat
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks