LinkBack URL
About LinkBacks
in B4
Formula:
=SUMIFS('source data'!$B5:$M5,'source data'!$B$4:$M$4,B$3,'source data'!$B$3:$M$3,B$2)
Copy across and down
No need for IF statement
in B4
Formula:=SUMIFS('source data'!$B5:$M5,'source data'!$B$4:$M$4,B$3,'source data'!$B$3:$M$3,B$2)
Copy across and down
No need for IF statement
Last edited by JohnTopley; 07-05-2024 at 05:33 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks