- Jul 13, 2005
I have a spreadsheet with bowling scores in three columns. Cells D3..F6,D12..F12,D21..F24, and D30..F33. I also have a column B with M and F for bowler sex. I can calculate the highest game bowl using =MAX. However, I am having trouble calculating the Max for Male and for Female with one formula. I think part of the problem may be the gaps in the cells listed above, due to calculating the total of the cells for team total. I’m not sure how I need to modify the MAX formula or if I need to used a different function completely. Any help in this matter would be greatly appreciated.