I'm trying to create a spreadsheet with pretty advanced formulas. I need to
create a function that first looks up column 1, and then if column one is
equal to "belgium" or a certain other word, then I need the function to sum
the following column if it matches a different criteria. I thought vlookup
might help by seaching for the first criteria, and then a nested sumif
function to look up the second criteria and add it, but it didn't work. It
didn't give me any errors, but it didn't work correctly. Does anyone have
any ideas on what I can do to create this function? Sorry if this is vague,
I know what I need but i can't describe it very well. Thanks.

Hi
You can do this using a SUMPRODUCT formula, eg
=SUMPRODUCT((A2:A1000="Belgium")*(B2:B1000))
When using SUMPRODUCT, the ranges must be the same size and you cannot use
full columns

--
Andy.


"charline" wrote in message
...
I'm trying to create a spreadsheet with pretty advanced formulas. I need
to
create a function that first looks up column 1, and then if column one is
equal to "belgium" or a certain other word, then I need the function to
sum
the following column if it matches a different criteria. I thought
vlookup
might help by seaching for the first criteria, and then a nested sumif
function to look up the second criteria and add it, but it didn't work.
It
didn't give me any errors, but it didn't work correctly. Does anyone have
any ideas on what I can do to create this function? Sorry if this is
vague,
I know what I need but i can't describe it very well. Thanks.

Charline,

Something along the lines of

=SUMPRODUCT((A1:A100="Belgium")*(B1:B100="Charline ")*C1:C100)

or use a pivot table.

HTH,
Bernie
MS Excel MVP


"charline" wrote in message
...
I'm trying to create a spreadsheet with pretty advanced formulas. I need
to
create a function that first looks up column 1, and then if column one is
equal to "belgium" or a certain other word, then I need the function to
sum
the following column if it matches a different criteria. I thought
vlookup
might help by seaching for the first criteria, and then a nested sumif
function to look up the second criteria and add it, but it didn't work.
It
didn't give me any errors, but it didn't work correctly. Does anyone have
any ideas on what I can do to create this function? Sorry if this is
vague,
I know what I need but i can't describe it very well. Thanks.

Hi. charline. Try this site. I Think SUMPRODUCT will do what you need.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Sincerely, Michael Colvin


"charline" wrote:

I'm trying to create a spreadsheet with pretty advanced formulas. I need to
create a function that first looks up column 1, and then if column one is
equal to "belgium" or a certain other word, then I need the function to sum
the following column if it matches a different criteria. I thought vlookup
might help by seaching for the first criteria, and then a nested sumif
function to look up the second criteria and add it, but it didn't work. It
didn't give me any errors, but it didn't work correctly. Does anyone have
any ideas on what I can do to create this function? Sorry if this is vague,
I know what I need but i can't describe it very well. Thanks.