Hello Friends,
Can you please help me regarding the formula in Cell D54, is there any way out to automate and drag it till cell Q57 instead of doing manual multiplication.
Please help.
Multipication.png
Hello Friends,
Can you please help me regarding the formula in Cell D54, is there any way out to automate and drag it till cell Q57 instead of doing manual multiplication.
Please help.
Multipication.png
Please try at D54
=SUMPRODUCT(D3:D48*D4:D49,--($C$3:$C$48=$C$3))/D53
With reference to the post #2 formula: Is it divide by D53 or should it be D$53 ??
I'm thinking that the divisor possibly should be "Production quantity" (row 53) for all four cost types in "Group".
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
D53 cell formula , Drag right
HTML Code:
D54 cell formula , Drag down and accross
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks