ExcelBanter - from sumproduct to a lookup please

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - from sumproduct to a lookup please (https://www.excelbanter.com/excel-worksheet-functions/16363-sumproduct-lookup-please.html)

Steved

from sumproduct to a lookup please

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.

Steved

Please ignore as I've now re done the question.

Thankyou.

-----Original Message-----
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.
.

All times are GMT +1. The time now is 07:03 AM.