Dear All,
I am unable to sum the data based on certain criteria. Please refer the sample sheet attached and let me know what is the error in the formula.
Regards,
Gem
Dear All,
I am unable to sum the data based on certain criteria. Please refer the sample sheet attached and let me know what is the error in the formula.
Regards,
Gem
try
D9Formula:Please Login or Register to view this content.
Highlighted part was D9 in your file which is referring the same cell where you were trying to putting the formula . That is why it was not working
ortry
D9Formula:Please Login or Register to view this content.
Last edited by shukla.ankur281190; 04-24-2017 at 02:18 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Wrong criteria mentioned "D9" instead of "B9" kindly change.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hi Shukla,
I have applied the formula in my sheet but still the results are not coming. Refer the attachment.
Pls help.
Regards,
Gem
Try
=IF(D$3<>"",(SUMPRODUCT(('CR Tracker'!$AC$3:$AC$500>=Report!D$3)*('CR Tracker'!$AC$3:$AC$500<=Report!F$3)*('CR Tracker'!$F$3:$F$500=Report!$D$5)*('CR Tracker'!$J$3:$J$500=Report!$B11))),"")
Make sure all the ranges are the same
And please add a sensible location to your account details.
Last edited by JohnTopley; 04-24-2017 at 11:27 AM.
As John said in post #5 Ranges should be same while you are using sumproduct function. See the below bold part.
Formula:Please Login or Register to view this content.
After change in Range Use below formula
Formula:Please Login or Register to view this content.
I am try to extract the data using the below formula, but it is not working. Sample file attached...
{=IFERROR(INDEX('CR Tracker'!D$3:D$646,SMALL(IF('CR Tracker'!AC$3:AC$646>=Report_Summary!$D$2)*('CR Tracker'!AC$3:AC$646<=Report_Summary!$F$2)*(Report_Summary!=$D$4),ROW(Report_Details!$B$6:$B$200)-ROW(Report_Details!$B$6)+1," "),ROWS(Report_Details!$B$6:H6))),"")}
Please help.
Gem
Duplicate post (last post)
see reply here...
http://www.excelforum.com/excel-form...king-help.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks