sopranoiam
Board Regular
- Joined
- Oct 16, 2002
- Messages
- 88
a b c d e
5 Fort Belvoir Kreiger 12,000
4 Quantico Kreiger 10,000
3 Fort Myer Kreiger 7,500
1 Dahlgren Kreiger 4,000 0
Please help me figure out why I can't autosum the total of column d in the cell of column e where the 0 is.
The cells are all formatted correctly with numbers, column d contains an IF statement which runs correctly. But when I tell e5 to autosum d2:d5, the result is always 0. What am I doing wrong? I've tried to remove the formatting and re-enter it and the info and the result is always the same.
5 Fort Belvoir Kreiger 12,000
4 Quantico Kreiger 10,000
3 Fort Myer Kreiger 7,500
1 Dahlgren Kreiger 4,000 0
Please help me figure out why I can't autosum the total of column d in the cell of column e where the 0 is.
The cells are all formatted correctly with numbers, column d contains an IF statement which runs correctly. But when I tell e5 to autosum d2:d5, the result is always 0. What am I doing wrong? I've tried to remove the formatting and re-enter it and the info and the result is always the same.