Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You could employ helper cells located somewhere else on your sheet and
do a sum of those. Using your setup. Column A = Student Name: Columns B - G = Test Answers 1 - 6 Lets use AB as your 1st Helper-Cell: AB = IF($B3=$B$2,1,0) AC = IF($C3=$C$2,1,0) AD = IF($D3=$D$2,1,0) AE = IF($E3=$E$2,1,0) AF = IF($F3=$F$2,1,0) AG = IF($G3=$G$2,1,0) ..... .... ... .. Copy formula's down as required. And finally, to total each row of Helper-Cells: Again, lets assume it Column H. H3 = SUM($AB3:$AG3) H4 = SUM($AB4:$AG4) ..... .... ... .. Copy formula's down as required. HTH Mick. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Negative Standard Deviations? | Excel Discussion (Misc queries) | |||
How many Standard Deviations above and below the mean each number is. | Excel Worksheet Functions | |||
Calculate 2 Standard Deviations | Excel Worksheet Functions | |||
Graph Standard Deviations | Excel Discussion (Misc queries) | |||
Standard deviations in Excel | Charts and Charting in Excel |