Home

What's wrong with this formula?

Deleted
Not applicable

It should be simple enough (but clearly i'm missing something), if there's a value in columns (E,F,G,H) that number is multiplied by the corresponding dollar amount in cells (N3,O3,P3,Q3) respectively to give me a total.  What am i'm overlooking?   Any help is greatly appreciated.    

1 Reply

Hi @Deleted 

 

Try this formula in cell I2:

 

=SUM($E3*$N$3, $F3*$O$3, $G3*$P$3, $H3*$Q$3)

 

Essentially you need to lock down the reference cells where the legend sits. This is done using Absolute Cell referencing using $ in front of the column letter and row number.

 

See this image below and you'll see that when I autofill thye formula downwards, it always references the legend so my calculations will always be accurate.

 

capture20190213143745633.png

 

I've attached the file I have mocked up for you to see things in action.

 

Best wishes!

 

Cheers

Damien

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies