| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplicity is Desired
Hi to all, =SUM(((COUNTIF(E20:J20,"a")+COUNTIF(E20:J20,"I"))* 10+(COUNTIF(K20:P20,"a")+COUNTIF(K20:P20,"I"))*20+ (COUNTIF(Q20:S20,"a")+COUNTIF(Q20:S20,"I"))*30+(CO UNTIF(T20:W20,"a")+COUNTIF(T20:W20,"I"))*20))/2 This formula that I have put together gets the desired result, but I am seeking a simpler version. Many thanks. Nate. -- natei6 ------------------------------------------------------------------------ natei6's Profile: http://www.excelforum.com/member.php...fo&userid=7185 View this thread: http://www.excelforum.com/showthread...hreadid=531425 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! Formula that can Ref. hidden data & Populate Cells with desired text | Excel Worksheet Functions | |||
| Delete all data (formulas) below a desired row. | Excel Discussion (Misc queries) | |||
| Linking across worksheets not working as desired | Excel Worksheet Functions | |||
| highlight range if cell contains desired data | New Users to Excel | |||
| hiding all data in a sheet except desired | Excel Worksheet Functions | |||
Threaded Mode
