Hi please can someone help. i have just done a few mock exams for an
Advanced Excel course that i am sitting in 3 days and there are a few
questions that have absolutely flumoxed me. can anyone shine any light on
these please.


1) calculate the sum of contracts by country greater than 5
2) calculate the highest individual projected revenue of all countries
with greater than 3 contracts and projected revenue greater than 25
3) calculate the projected revenue increase for the year 2002 using set
contidione ie less than 30 projeected increase = 3%

I know this wont make much sence to you unless you see the worksheets i am
working on. i just need to know where i can find information on how to build
up formulas that can do this.

was doing quite well till these popped up. i have been through help and
none of it makes any sence
--
Thank you for reading my post. Hopefully you can answer my querie

All three sound like you're trying to do calculations based on multiple
criteria. Given those scenarios, I would tackle them using SUMPRODUCT.
Sumproduct can mutliply sevearl arrays (usually created by a criteria check
creating TRUE/FALSE sets) and then a final multiplication against the numbers
you want. (since TRUE*TRUE*5 = 5).

Link to a site that uses/explains SUMPRODUCT

http://www.mcgimpsey.com/excel/variablerate.html

And of course, you can prb do a search of these forums for "sumproduct" and
get results similar to what you're looking for.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shazza" wrote:

Hi please can someone help. i have just done a few mock exams for an
Advanced Excel course that i am sitting in 3 days and there are a few
questions that have absolutely flumoxed me. can anyone shine any light on
these please.


1) calculate the sum of contracts by country greater than 5
2) calculate the highest individual projected revenue of all countries
with greater than 3 contracts and projected revenue greater than 25
3) calculate the projected revenue increase for the year 2002 using set
contidione ie less than 30 projeected increase = 3%

I know this wont make much sence to you unless you see the worksheets i am
working on. i just need to know where i can find information on how to build
up formulas that can do this.

was doing quite well till these popped up. i have been through help and
none of it makes any sence
--
Thank you for reading my post. Hopefully you can answer my querie

Luke you are a star. Thank you very much. That certainly answered one of my
queries. i too tired now to check the others out but will read the site in
full tomorrow. Thank you very very much :0)
--
Thank you for reading my post. Hopefully you can answer my querie


"Luke M" wrote:

All three sound like you're trying to do calculations based on multiple
criteria. Given those scenarios, I would tackle them using SUMPRODUCT.
Sumproduct can mutliply sevearl arrays (usually created by a criteria check
creating TRUE/FALSE sets) and then a final multiplication against the numbers
you want. (since TRUE*TRUE*5 = 5).

Link to a site that uses/explains SUMPRODUCT

http://www.mcgimpsey.com/excel/variablerate.html

And of course, you can prb do a search of these forums for "sumproduct" and
get results similar to what you're looking for.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shazza" wrote:

Hi please can someone help. i have just done a few mock exams for an
Advanced Excel course that i am sitting in 3 days and there are a few
questions that have absolutely flumoxed me. can anyone shine any light on
these please.


1) calculate the sum of contracts by country greater than 5
2) calculate the highest individual projected revenue of all countries
with greater than 3 contracts and projected revenue greater than 25
3) calculate the projected revenue increase for the year 2002 using set
contidione ie less than 30 projeected increase = 3%

I know this wont make much sence to you unless you see the worksheets i am
working on. i just need to know where i can find information on how to build
up formulas that can do this.

was doing quite well till these popped up. i have been through help and
none of it makes any sence
--
Thank you for reading my post. Hopefully you can answer my querie