LinkBack URL
About LinkBacks
Assuming that these values will go at the bottom of the sheet in column G, the following formula populates G47 and down:Let us know if you have any questions.Formula:
=SUMPRODUCT(($C$1:$H$1=$B48)*($B$6:$B$40=$A48)*(C$5:H$5=C$47)*(C$6:H$40>0))
Assuming that these values will go at the bottom of the sheet in column G, the following formula populates G47 and down:Let us know if you have any questions.Formula:=SUMPRODUCT(($C$1:$H$1=$B48)*($B$6:$B$40=$A48)*(C$5:H$5=C$47)*(C$6:H$40>0))
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks