Good evening all, I am doing a formula with a long SumProduct in ti and I have got to the stage where it almost works but for some reason will not work when it comes to dividing anothe SumProduct formula. I have attached a sheet with the necessary data in it and explained what I am after. If anyone could help me out then this would be greatly appreciated.
try
H432=(SUMPRODUCT(($G$2:$G$420="Norm")*($J$2:$J$420="2100.AHD")*($H$2:$H$420))+SUMPRODUCT(($J$2:$J$420="2100.AHD")*($G$2:$G$420>499)*($G$2:$G$420<700)*($H$2:$H$420))+SUMPRODUCT(($J$2:$J$420="2100.AHD")*($G$2:$G$420>="OT15")*($G$2:$G$420<="OT20")*($H$2:$H$420)))/SUMPRODUCT(($G$2:$G$420="Norm")*($J$2:$J$420="2100.AHD")*($I$2:$I$420))
Whenever we do math operation with formula, we must parenthesis add correctly. See the bold part of above formula
Last edited by shukla.ankur281190; 02-05-2016 at 02:54 AM. Reason: Missing Info
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)
Thank you so much for your prompt and very correct solution Ankur. It worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks