If you are going to use the formulas provided, I presume you will need to be
able to explain how and why they work. The SUMPRODUCT formula given is not
documented in this way anywhere in MS (
AFAIK), so you might have a problem.
Pierre gives some explanation at
http://www.excel-vba.com/e-formula-sumproduct.htm, but this tells you it
works and how to use it, not why it works. You might want to check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html and quote these 2 pages
as references in your submission.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Pierre Leclerc" wrote in message
...
Hi Sam
Please don't fall in love with me unless you are Samantha
Discover the amazing world of SUMPRODUCT
=SUMPRODUCT((A1:A100="Dubai")*(B1:B100="Portland") *(C1:C100))
In plain English sum column C if in the coreesponding cell of column A
there is "Dubai" and in the corresponding cell of column B there is
Portland. As there is only one value that satisfies the conditions,
you get your answer
Find out all that you need to know about SUMPRODUCT at:
http://www.excel-vba.com
On Sun, 21 Nov 2004 07:57:52 -0600, SamUK
wrote:
Hiya everyone,
I'm having some trouble getting a VLOOKUP to work in a spreadsheet. I'm
designing a spreadsheet for school, which should automatically calculate
how much it costs to fly to places etc.
Anyway, as I said, I'm having trouble with a VLOOKUP. I want my
spreadsheet to calculate how much it costs to fly from City A to City
B. I have another sheet called "Prices" which contains 3 columns:
Departure City, Arrival City and Price. For example, the first row has
"East Midlands, Dubai, £300"
So far, so good.
However, I also have a flight from East Midlands to London Gatwick and
this is where the problem arises. You see, my VLOOKUP only looks into
the first column (departure airport) so if, for example, I had chosen
East Midlands on my first sheet, it would choose the price attached to
the East Midlands to Dubai flight. I can't get it to check out the
second column (arrival airport), so it just inserts the first one,
whether it's London or Dubai.
I would *really* fall in love with anyone who helps me, 'specially
since this is due in tomorrow and is worth 30% of my final grade! I
know this account gives me a semi-literate appearance, and I apologize
if I'm not clear, so just ask if you need anything clarifying.
Many thanks,
Sam
Pierre Leclerc
http://www.excel-vba.com