Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with two Bowling Formulas
I have setup a spreadsheet to keep track of my personal bowling scores. I
have made everything automatic except 2 formulas that I cannot figure out, can someone help? 1) Series Total column. I have a row of 3 numbers that get a simple SUM formula in the 4th column of that row. These series totals range in a column from G4 - G32. I have conditionally formatted them so that if the formula result is zero, paint the cell white so I don't see the zeros. So in this formula column, I only get an actual formula result when I actually have scores input in the rows. I want to find the MIN series total in the entire column, but the MIN formula is giving me a zero (because I have hidden zeros). How can I get the minimum actual number, not being a zero. 2) I need to figure high series WITH handicap added in. Say G8 has high series number, I need to multiply J7 by 3 then add this to the high series number in G8. How do I do this? I need the cell number for the high series returned, so that I can point the J column cell # to one less than the G column cell #. TIA, -Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |