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.