I don't know of a way around the F2:F4. The only possibly helpful thing is that the IF at the end of the formula can be eliminated by ($D$2:$D$10=F2)*(G2:H2))
I don't know of a way around the F2:F4. The only possibly helpful thing is that the IF at the end of the formula can be eliminated by ($D$2:$D$10=F2)*(G2:H2))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks