I think a simple sum if will work fine however better to name ranges
Paste this in to J3
=SUMIF($B$4:$E$59,I3,$E$4:$E$59)
Drag down to copy formua
I think a simple sum if will work fine however better to name ranges
Paste this in to J3
=SUMIF($B$4:$E$59,I3,$E$4:$E$59)
Drag down to copy formua
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks