from sumproduct to a lookup please

S

Steved

Steved

Hello from Steved

Below will do a sum off 1-City how do I change it to do a
lookup please.

SUMPRODUCT(--(Data!$A$2:$B$2001="1-City"))

Thankyou.
 

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

In column B:B and D:D I've a Formula 6
Text Wrap 5
ignore "0" 9
Formula please to put a word in the left Cell ( "Roster" ) 3
106% to this please 6% 7
Make them work on the Each cell Value 7
Show's #N/A please to showblank. 2
Corporated into the same fromula please. 5

Top