Sum on horizontal lookup.

J

J.W. Aldridge

in one row (a10:aa10), i have a name in one cell, then value in the
next, name in one cell, then value in the next...

Some of the names in the row are repeated. Based on a lookup value
(which will be one of the names), I want to:

search the row for the lookup value
add the value to the right each time the lookup value is found.

example:
a10 a11 a12 a13 a14 a15 a16 a17
errors 10 correct 10 errors 10 correct 20

lookup value "errors", result 20
lookup value "correct", result 30
 
J

JP Ronse

Hi,

Try sumif ...
=sumif(a10:a16;"errors";a11:A17)

&

=sumif(a10:a16;"correct";a11:A17)

Hope this helps.

Wkr,

JP
 

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

how to use an formula to transpose a list(left) to be like the right? 2
...lookup? 3
Data Compare 1
Doing a VLOOKUP (probably using the INDEX and MATCH function), withboth vertical and horizontal valu 2
formula or code help 3
LOOKUP problem 2
Lookup data based on 3 criteria 5
Autofill cells in 1 column :code ?? 2

Top