Hi, i have a small problem with a spreadsheet im creating! On the spreadsheet i have 3 different pages each with different calculations on it, on a 4th page i need to add some of the totals up from each of the three sheets. Is there any way i can get the 4th page to do something like this.... If b3 (on 1st page) is between 24 and 25 select f6, if b3 (on the 1st page) is between 31 and 35 select g6 and if b3(on the 1st page) is 36+ select h6 I know its confusing but any help wud be appreciated!!! I've attatched the doc if anyone needs a closer look
