Or if column E is numbers (and there could only be one match) you can use this:
=SUMIFS('Home BU'!$E:$E,'Home BU'!$A:$A,$A7,'Home BU'!$B:$B,"")
Or if column E is numbers (and there could only be one match) you can use this:
=SUMIFS('Home BU'!$E:$E,'Home BU'!$A:$A,$A7,'Home BU'!$B:$B,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks