MS Excel help please

SmooveB

Member
Jun 5, 2002
115
0
0
In Microsoft Excel I want to sum each number from column A with another number.

The line I used looks like this: =SUM(A2,-400)

How do you make it automatically do that for the entire column without placing =SUM(A3,-400), SUM(A4,-400), etc. in each column?
 

Shagga

Diamond Member
Nov 9, 1999
4,421
0
76
Bit long winded this but for speed you could do this. "=SUM(A1:A10)-(COUNTIF(A1:A10,">0")*400)"

:)