horizontal sumif help

M

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

T. Valko

Numbers formatted as TEXT.

Leading and/or trailing spaces.

There's nothing wrong with the formula.

Biff
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with 12 week rolling average 3
looking for a solution 1
Combining several cells into single equasion? 1
How to set cell value to emptry if three other columns are empty too 1
Count non-consecutive cells..... 7
How do I combine the 4 IF formulas into 1 formula 5
Checkbox to hide and unhide rows Please. 2
Compare month to month data 1

Top