horizontal sumif help

[Marcelo]

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

 

[T. Valko]

Numbers formatted as TEXT.

Leading and/or trailing spaces.

There's nothing wrong with the formula.

Biff

 

[Martin Fishlock]

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?