The sum range in my formula includes 3 columns. My formula is working but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland

Maybe the other 2 columns are not true XL numbers, but text that just looks
like numbers.

See if you get a TRUE return from a formula like this:

=isnumber(A1)
where A1 is one of the cells not being totaled.


If all the cells return TRUE, post your formula.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"martinson" wrote in message
...
The sum range in my formula includes 3 columns. My formula is working but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland

Use SUMPRODUCT:

=SUMPRODUCT((A1:A10="x")*B1:D10)

--
Biff
Microsoft Excel MVP


"martinson" wrote in message
...
The sum range in my formula includes 3 columns. My formula is working but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland

Thank you... that one worked
--
martinson portland


"T. Valko" wrote:

Use SUMPRODUCT:

=SUMPRODUCT((A1:A10="x")*B1:D10)

--
Biff
Microsoft Excel MVP


"martinson" wrote in message
...
The sum range in my formula includes 3 columns. My formula is working but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"martinson" wrote in message
...
Thank you... that one worked
--
martinson portland


"T. Valko" wrote:

Use SUMPRODUCT:

=SUMPRODUCT((A1:A10="x")*B1:D10)

--
Biff
Microsoft Excel MVP


"martinson" wrote in message
...
The sum range in my formula includes 3 columns. My formula is working
but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland

Without seeing the formula (**always a good idea to post any formulas you
refer to in your message), I would guess it is an array-entered formula
meaning you have to select the cell with the formula, then put the cursor in
the formula bar and press Ctrl+Shift+Enter to commit it. Once you have done
that, you can copy the formula down or across normally (if needed).

Rick


"martinson" wrote in message
...
The sum range in my formula includes 3 columns. My formula is working but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland

same problem here

=IF(SUMIF(Programa!$A$5:$A$94,$M6,Programa!U5:AB94 )0,1,0)

i'm trying to check within a range (u5:ab94) if there are values
based on the content in column A
but it only return a 1 if the numbers are in the first column (in this case:
U)

-the problem is that i have values in columns W, X, etc
and it still returns a 0




"martinson" wrote:

The sum range in my formula includes 3 columns. My formula is working but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland