| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for % passing
need formula to count only grades above 70
Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for % passing
=COUNTIF(A:A,"70%")
-- Regards, Peo Sjoblom "RKing" wrote in message ... need formula to count only grades above 70 Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for % passing
Let's say your data is in A1:A100
=COUNTIF(A1:A100,"70%") HTH, Barb Reinhardt "RKing" wrote: need formula to count only grades above 70 Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a row to a function | Excel Worksheet Functions | |||
| Passing values in Sheet to VBA | Charts and Charting in Excel | |||
| Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
| Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) | |||
| Passing Variables | Excel Discussion (Misc queries) | |||
Linear Mode
