See workbook for clarity.
See workbook for clarity.
Try this...
This formula entered in L4 and copied down:
=SUMIF(A$2:G$2,J4,A$20:G$20)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That works. Thanks!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks