Find a value across multiple ranges of the same row.

[mtaylor]

Good day,

Thanks for reading.

I currently have this:

= SUMPRODUCT( (D5:N5="G")*7 + (D5:N5="A")*4 + (D5:N5="R")*1 )

Which is beautiful, thank you to PeteWright

However I'm now after some more cells being included but not adjacent to the existing ones.

For example search between D5 and N5 as usual, but now also include O5 to W5?

I tried this:

= SUMPRODUCT( (D5:O5,R5:W5="G")*7 + (D5:O5,R5:W5="A")*4 + (D5:O5,R5:W5="R")*1 )

To no success.

Thanks for the time.

 

[Fluff]

Duplicate to: Assign different letters different values across a range of cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.