SUM without prefix
On Tue, 1 Jan 2008 19:13:00 -0800, Boris
wrote:
Hi,
Could someone teach me how to add numbers without prefix column.
A
1 @101
2 102
3 @103
4 104
-----------
6 106
I need a function that could add 102 and 104 and result 106. I tried with
SUMPRODUCT and it doesn't seem to work. Prefix "@" was setup in column A1
and A3 to atuo input. Please help out.
Thanks,
Boris
I can't help you with adding 102 and 104 to get 106. Possibly you mean 206?
If I understand you correctly, your cells contain:
A1: @101
A2: 102
A3: @103
A4: 104
In any event, if the values above are in Column A, and if the @ is present also
(not as a format, but as the actual character), then you can use the SUM
function
=SUM(A1:A4)
The values with the preceding @ should be being interpreted as TEXT, which the
SUM function will ignore.
--ron
|