• 462K Members
• 5,483 Online
• 559K Conversations

New Contributor

# Formula in a table : use structures reference vs pointing to a cell

hello,

I'm struggling to find my solution :-)

I'm using a table, and making calculation in it :

A / B / C / D / E / F / G / H / 1 / 2 / 3 / 4...

I would like to make a formula doing : (\$ means keep the same column as in \$A1)

typing in column C = \$A * \$B * 1

and when copying or draging the formula from C to H get automatically:

in column E = \$A * \$B * 2

in column F = \$A * \$B * 3

in column G = \$A * \$B * 4

...

If I  type in column C :

=[@A]*[@B]*[@1] then if I copy the cell C in the cell D I get : =[@A]*[@B]*[@1] so it keeps A and B as I want, but takes 1 instead of 2

If I  type in column C :

=[@A]*[@B]*[@1] then if I drag the cell C in the cell D I get : =[@B]*[@C]*[@2] so it takes 2 into account but don't keep A and B

I hope I'm clear enough :-)

Any idea please ? thanks for any help.

3 Replies

# Re: Formula in a table : use structures reference vs pointing to a cell

You may use

`=[@[A]:[A]]*[@[B]:[B]]*[@1]`

# Re: Formula in a table : use structures reference vs pointing to a cell

**bleep** soo easy :-)

I've been looking for this solution for a long time ! great thanks Sergei !!

# Re: Formula in a table : use structures reference vs pointing to a cell

Each of us constantly finds something new in Excel, it's infinite

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies