| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
That's it! Thanks, Ron!!
"Ron Coderre" wrote in message ... If your data table starts in A1 and the data begins in row 2: Try putting this formula in Cell E1: =SUM(1/COUNTIF($A$2:$A$10,$A$2:$A$10)*$D$2:$D$10) (Note: Commit that array formula by pressing [Ctrl]+[Shifr]+[Enter] Regards, Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| How to countif involving another column? | Excel Worksheet Functions | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| How Do I created a nested sumif - if this column has this and thi. | Excel Worksheet Functions | |||
Threaded Mode
