SUMIF sum range

[martinson]

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?

 

[RagDyeR]

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!
=====================================================


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?

 

[T. Valko]

Use SUMPRODUCT:

=SUMPRODUCT((A1:A10="x")*B110)

 

[Rick Rothstein \(MVP - VB\)]

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]

Thank you... that one worked

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Alonso]

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