Thread
:
Lookup
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Lookup
Your are very welcome, I'm glad you found it useful
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"AFA" wrote in message
...
Hi Sandy
Thank a lots. its work! you save a lot of my time scrolling down a hundred
of line and updating items manually.
"Sandy Mann" wrote:
Country in Column A, Month in Column B & Value in Column C:
=SUMPRODUCT((A2:A7="Germany")*(B2:B7=9)*C2:C7)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"AFA" wrote in message
...
Hi,
Country Month Value
Germany 1 100.00
Germany 5 250.00
UK 7 400.00
Spain 2 300.00
UK 5 250.00
Germany 9 710.00
I need to pull out the value that match to Country=Germany and Month=9.
I am sure Vlookup or offset are not possible.
What formula should I write?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann