Hello,
I'm in search for a sumproduct formula with a condition that uses a reference. I.o.w. in the attached file I'd like the yellow cells to return 45 and 45 respectively.
Has anybody got an idea how to fix this?
Kind regards,
Niels
Hello,
I'm in search for a sumproduct formula with a condition that uses a reference. I.o.w. in the attached file I'd like the yellow cells to return 45 and 45 respectively.
Has anybody got an idea how to fix this?
Kind regards,
Niels
My suggestion is in your Column G1 copy down the formula
=SUMIF($A$1:$A$5,F1,$B$1:$B$5)+SUMIF($A$1:$A$5,F1,$C$1:$C$5)
or it could be
=SUMPRODUCT(($A$1:$A$5=F1)*($B$1:$C$5))
hope it helps
Rev12
Last edited by Rev12; 06-15-2018 at 08:25 AM.
hi ! try below in G1
Formula:Please Login or Register to view this content.
if this helps then add rep by clicking star at the bottom left corner of this post
Not sure where you get 45 and 45 from? You have 54 appels
=SUMPRODUCT(--($A$1:$A$5=F1),$B$1:$B$5*$C$1:$C$5)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks