selecting range

maumau2037j

New Member
Joined
Oct 26, 2006
Messages
2
I need to calculate the sum like (A1 - X1) + (A2 - X1) + (A3 - X1) ... (A100 - X1). What is easy way to write the sum in Excel please? Thanks a lot.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,928
Office Version
  1. 365
Platform
  1. Windows
How about this?

=SUM(A1:A100)-100*X1
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,621
Members
410,804
Latest member
bluepinky
Top