Hi,

I'm trying to do this

=sumif(A1:G1,"HO",K1:Q1)


A1 B1 C1 D1 E1 F1 G1 ....K1 L1 M1 N1 O1 P1 Q1.........AZ (RESULT)
O HO O O O HO O 2 4 5 56 2 2 1 6


But don't work, any idea?

Thanks!

Marcelo

Numbers formatted as TEXT.

Leading and/or trailing spaces.

There's nothing wrong with the formula.

Biff

"Marcelo" wrote in message
ups.com...
Hi,

I'm trying to do this

=sumif(A1:G1,"HO",K1:Q1)


A1 B1 C1 D1 E1 F1 G1 ....K1 L1 M1 N1 O1 P1 Q1.........AZ (RESULT)
O HO O O O HO O 2 4 5 56 2 2 1 6


But don't work, any idea?

Thanks!

Marcelo

It works old chap.

Ho = cell 2 and cell 6

ie L1 = 4 and P1 = 2 sum =6 result.

What did you want?

Or have you got spaces in your data?



--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Marcelo" wrote:

Hi,

I'm trying to do this

=sumif(A1:G1,"HO",K1:Q1)


A1 B1 C1 D1 E1 F1 G1 ....K1 L1 M1 N1 O1 P1 Q1.........AZ (RESULT)
O HO O O O HO O 2 4 5 56 2 2 1 6


But don't work, any idea?

Thanks!

Marcelo