LinkBack URL
About LinkBacks
ursanil 
Hi,
For corresponding dates I have two things Sales and calls.
In summary table when I select date I should get the summation till that date. Attached a example excel sheet.
Thanks in advance
Hi,
For corresponding dates I have two things Sales and calls.
In summary table when I select date I should get the summation till that date. Attached a example excel sheet.
Thanks in advance
Consider using SUMIFS...
For instance, for 'Target Sales' you could try:
=SUMIFS($B$3:$B$14,$A$3:$A$14,">="&$K$1,$A$3:$A$14,"<="&$M$1)
Then just change the sum range (the range in red) to match the columns for the other parts.
- Moo
Last edited by Moo the Dog; 03-01-2014 at 12:41 PM.
Hi ursanil
If you name the ranges B3:C14 to "Taget" & D3:E14 to "Achieved" as you have done for the dates in A3:A14 then you can use the SUMIFS in I3 and copy across & down to J4.
Formula:
=SUMIFS(INDEX(IF(I$2="Taget",Taget,Achieved),,MATCH($H3,$B$2:$C$2,0)),Dates,">="&$K$1,Dates,"<="&$M$1)
See the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks