Learn more about sumproduct here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
The formula you're looking for is
=Sumproduct((F1:F100="BPS")*(P1:P100="General")*(I1:I100))
Learn more about sumproduct here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
The formula you're looking for is
=Sumproduct((F1:F100="BPS")*(P1:P100="General")*(I1:I100))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks