Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
HI, Can someone PLEASE HELP!!!!!!!!!!!!!!!!!
I am using the following count to count how many time a number above 70 is input, I need to add M or F onto the end of the numbers. e.g. 74M, the formula i'm using does not recognise both number and text. this is the formula i'm using: =COUNTIF(Interventions!C19:C81,"70") I need to add a letter M and F onto the end of this formula to recognise input of e.g. 74M, 86M, 95F to place in correct cells on a different worksheet. 70+ Males for M & 70+ Females for F Can anyone HELP!!!!!!!! Its doing my head in... Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for counting number of cells | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula for counting specific cells with value greater than 0 | Excel Discussion (Misc queries) | |||
Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) |