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