Let's say this other column is J and you put low value (0) in C5 and high value (3) in D5. Just add those condtions to your existing formula.
=(SUMPRODUCT(($H$17:$H$5000>=A5)*($H$17:$H$5000<=B5)*($J$17:$J$5000>$C$5)*($J$17:$J$5000 <= $D$5)*($D$17:$D$5000))
Does that work?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Dani8826 
Register To Reply
Bookmarks