I am trying to calculate something using the following formula, but it returns with an error please help
=SUMPRODUCT(--($D$2:$D$5229>=B$5231),--($D$2:$D$5229<=B$5232),--($Y$2:$Y$5229="2"))/SUMPRODUCT(--($D$2:$D$5229>=B$5231),--($D$2:$D$5229<=B$5232),--($Y$2:$Y$5229="1"))
I am using Excel 2010
Regards
yeah, i get divide by zero error too
Elegant Simplicity............. Not Always
Hi
if your values for range Y2:Y5229 are number, remove the double quotes $Y$2:$Y$5229=2
Otherwise please perhaps post a small sample sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks