If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#22
|
|||
|
|||
Excellent it worked!! Thanks so much for your help!!!
"N Harkawat" wrote: =MIN(IF(--(A3:A9="Front")*(B3:B90),B3:B9)) "sonofroy" wrote in message ... How do I get the Minimum for the rounds on the "Front" without it returning zero. I am using the =MIN(IF(a3:a9="Front",B3:B9)) and it returns zero "Don Guillett" wrote: unmerge em. -- Don Guillett SalesAid Software "sonofroy" wrote in message ... I used CSE but it told me formula would not work in merged cells. "Don Guillett" wrote: happens every time when you don't enter array formulas with CSE -- Don Guillett SalesAid Software "sonofroy" wrote in message ... I am also trying to show my High and Low Rounds on the front and back I am using =MAX(if(a3:a9="Front",B3:b9)) and I get #value! And I can not figure out a formula for the Low round on the front Can you help we these also? Thanks "Don Guillett" wrote: Pretty good golfer -- Don Guillett SalesAid Software "sonofroy" wrote in message ... Thanks in this formula does it throwout any zeros found in "b" column for the MIN? "Don Guillett" wrote: try this ARRAY formula which must be entered with ctrl+shift+enter. ONE line =(SUM(IF(A3:A9="Front",B3:B9))-MIN(IF(A3:A9="Front",B3:B9))-MAX(IF(A3:A9="Fr ont",B3:B9)))/(COUNTIF(A3:A8,"Front")-2) -- Don Guillett SalesAid Software "sonofroy" wrote in message ... Hi I have a golf handicapping spredsheet set up like this B C Front 41 Back 30 Front 53 Back 43 Front 37 Back 29 I am trying to get an average for the data in "C" for the "Front" and then seperately for the "Back" But this average needs to throw out the high and low. SUMPRODUCT will not give me a count of Fronts and Backs, and AVERAGE will not work because I can not get a min function to leave out zeros. Help Please! Thanks a bunch |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sumproduct for getting counts | Dan | Worksheet Functions | 1 | April 5th, 2004 02:09 AM |