What are other ways to sum in Excel...?

[PP3321]

I have a problem with worksheet I inherited.

I have formulas like:

= A1 + Z1 + AD1 + DE1

The cells are so far apart...

I am wondering if there are any other ways to sum cells that are far apart...

Thank you...

 

[Deepak]

Can we have the logic behind the sum cells

 

[PP3321]

@Deepak, @NARAYANK991
Thank you for your reply.
Sorry I cannot upload excel file...

Quarter 1 Total Sales = 100 (Cell A1)
Quarter 2 Total Sales = 100 (Cell Z1)
Quarter 3 Total Sales = 100 (Cell AD1)
Quarter 4 Total Sales = 100 (Cell DD1)

Annual total Sales = A1 + Z1 + AD1 + DD1

The worksheet is painfully large...

*Pivot Table
*SubTotals?
*Sumifs...?

Can you throw me any functions which might be helpful here...?

 

[Deepak]

SUMIF would be nice.

 

[Hui]

=Sum(A1, Z1, AD1, DD1)

The best way is for you to upload a sample file
It doesn't have to be your real file, just the headings and enough dummy data so we can see the layout

Specifically which rows you want to add up and what are the column titles

 

[PP3321]

Hi @Hui
1. Thank you for your advice & I agree that it is best to post excel file.
Sorry I cannot upload the excel file now...

2. The excel file that I inherited looks like this.
It is painfully tall and has total for each city every 200 rows.

*I am hiding every 200 rows.
But in real life, it shows every row.

<problem>
-pain of going up and down
-pain of checking if the total formula is correct.

I like sum() because it is easier to see, at least.

 

[NARAYANK991]

Hi ,

Using the SUBTOTALS feature makes it painless.

See the attached file.

Narayan

 

[PP3321]

@NARAYANK991 Thank you!!!

 

[bosco_yip]

Or this ……

=SUMIFS(C:C,A:A,"City*",B:B,"Total Sales")

Regards
Bosco

 

[PP3321]

@bosco_yip

Thank you!!!!!