Aniruddha Chourasia
Last answered:

29 Sept 2022

 Posted on:

29 Sept 2022
0

Resolved: Cell reference!

in Introduction to Excel / Use Sumif to Complete the Database Sheet

When we are selecting the whole column so why is it further necessary to fix the column reference?

1 answers ( 1 marked as helpful)
Ned Krastev
Instructor
Posted on:

29 Sept 2022
0

Hi,
That's a best practice. We do that in case you want to paste the formula downwards.
Best,
Ned

Helpful answer

Submit an answer

related questions

Sakif Hossain
0
10
Error showing on cell #REF!
Charles Acheampong
0
6
Resolved: Custom cell formatting not working
Jesse Self
0
4
Sensitivity Analysis Reference
PRAKHAR PATEL
0
2
What if we have 1000 cell to apply goal seek?
Anas Alkhaldi
6
0
Is there another mapping reference online other than the one provided in the resources here?
Sharon Myburgh
0
0
renaming cell ranges
Brayan Delgado
1
0
Formula parameters calculating incorrect cell references?