A simple way is like this:
=SUMIF(B$1:B$9,D9,A$1:A$9) + SUMIF(B$1:B$9,E9,A$1:A$9) + SUMIF(B$1:B$9,F9,A$1:A$9)
Hope this helps.
Pete
A simple way is like this:
=SUMIF(B$1:B$9,D9,A$1:A$9) + SUMIF(B$1:B$9,E9,A$1:A$9) + SUMIF(B$1:B$9,F9,A$1:A$9)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks