SUMPRODUCT values from different locations if checkbox

[indygo]

Hi again, the best excel help in the internet!

Ok on the left hand side we have statistics for different people. There are average values, sums etc.
On the right hand side we have summary of the whole group. Now I'm using boxes to decide which people to sum up to see the differences and impact.
I've tried this code =SUMPRODUCT(($A:$A=TRUE)*$C$3, $C$7, $C$11)) but apparently this command "sumproduct" works only if rows are equal, so it's impossible to decide which cells are being calculated. Is there any way please? I'm sure there is, my excel knowledge is just too limited...

Cheers

 

[lrobbo314]

Does this do what you are looking for?

=SUMPRODUCT(($A:$A=TRUE)*$C$3*$C$7*$C$11))

 

[indygo]

It works in general but it gives me wrong calculation. Cells in Red should give me total of 342 and it gives me 696000 instead?
If I tick first box it gives my 232000 instead of 232.

 

[Aladin Akyurek]

Try to re-post. A picture requires retyping for further inquiry. Hope you don't expect a would-be helper to go thru that pain. Attachments lists a few methods for posting sample exhibits which do not require retyping and the add-in https://app.box.com/s/soezox25h3w0q5s4rcyl is also a method for posting an exhibit.

 

[indygo]

Try to re-post. A picture requires retyping for further inquiry. Hope you don't expect a would-be helper to go thru that pain. Attachments lists a few methods for posting sample exhibits which do not require retyping and the add-in https://app.box.com/s/soezox25h3w0q5s4rcyl is also a method for posting an exhibit.

I don't understand. What pain do you have in mind?

 

[Aladin Akyurek]

I don't understand. What pain do you have in mind?

Re-typing the data of your picture into Excel...