I need to use the "IF" formula on a worksheet with 15 variables. There is a limit of 7 that can be used at once, does anyone know a way around this?
Thank you for any help I can get!
I need to use the "IF" formula on a worksheet with 15 variables. There is a limit of 7 that can be used at once, does anyone know a way around this?
Thank you for any help I can get!
Last edited by MrStang; 02-27-2009 at 09:21 AM.
Several ways around it... can you give an example of what you are trying to do?
Note: I changed your title this time to be more descriptive of the problem, please read our forum rules about thread titles...
Last edited by NBVC; 02-26-2009 at 03:28 PM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I included my excel file. I need the second sheet to read what number is typed (aisle) return the number of cases from sheet1 ( ex. b4=3 then returns c7 from sheet 1) but I need that for all of the aisles (column b of sheet1)
So you want the sum of all cases where Aisle number is 3...
Put a 3 in B4 and then enter this formula in B5:
=SUMIF(Sheet1!$B$5:$B$37,B$4,Sheet1!$C$7:$C$37)
which you can copy across the row, aisles in row 3 will be looked up and summed.
I don't need the sum just the number of cases of the aisle # that is typed, If I would type in 3 into B4 on sheet 2 I would get back 10(cell c7 sheet1) into B5 of sheet 2. If I would type in 4 then I would get back the contents from C9 of sheet 1.
Unfortunately I have to leave right now I will return tomorrow morning. Thank you for the help.
Then:
=VLOOKUP(B$4,Sheet1!$B$7:$C$37,2,0)
This returns the value in C which matches the first occurance of the value in B that, in turn, matches B4 from Sheet2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks