| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
For those bu**ers that do the 1/2 and 1/2 H and T, we simply need to add the HT calculation into both formulas, as such: =COUNTIF(B2:Z2,"=H")+COUNTIF(B2:Z2,"=H2")/2+COUNTIF(B2:Z2,"HT")/2 and =COUNTIF(B2:Z2,"=T")")+COUNTIF(B2:Z2,"=T2")/2+COUNTIF(B2:Z2,"HT")/2 should work nicely for you. Cheers! Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=382566 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow Numeric Characters Only In A Cell | Excel Discussion (Misc queries) | |||
| Search string for alpha or numeric | Excel Worksheet Functions | |||
| Database text converted to numeric | Excel Discussion (Misc queries) | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
Threaded Mode
