Hi,

Do you possibly have the answer to my other posting "Add several functions
in one formula"?
--
Brile


"Charles Williams" wrote:

Its because Excel is treating the TX1, TX2 as text and TX11 is less than TX2
(sort the column ascending to see the comparison sequence).

You can either make all the TX1 to TX9 into TX01 to TX09 (make all the TX
strings the same length)

or use a helper column (C) on Sheet 2 to extract the numbers
=VALUE(RIGHT(A1,LEN(A1)-2))

and then change your SUMIF to
=SUMIF(Sheet2!$C$1:$C$30,"<=" &
RIGHT(Sheet1!A1,LEN(A1)-2),Sheet2!$B$1:$B$30)


regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Brile" wrote in message
...
Hi,

How do I get around Excel counting the first digit in 2 digit numbers, for
example 10, as 1 when I have added a SUMIF<= function. Example: I have 12
different columns, each named TX1, TX2 etc. And a formula that extracts
from
a different tab and counts the value if it is <= (less than or equal to)
the
current column. When Excel reaches to columns with 2 digit numbers it
starts
counting the 1 in the name TX10, and the 1 in the name TX11. How do I get
around this?

--
Brile