Hi santaviga,

Try something like:
=SUM(IF((LEFT(Interventions!C19:C81,LEN(Interventi ons!C19:C81)-1)^170)*(RIG
HT(Interventions!C19:C81,1)="M"),1,))
and
=SUM(IF((LEFT(Interventions!C19:C81,LEN(Interventi ons!C19:C81)-1)^170)*(RIG
HT(Interventions!C19:C81,1)="F"),1,))
both entered as array formulae (ie Ctrl-Shift-Enter).

for intermediate age ranges, the formulae could become:
=SUM(IF((LEFT(Interventions!C19:C81,LEN(Interventi ons!C19:C81)-1)^15)*(LEFT
(Interventions!C19:C81,LEN(Interventions!C19:C81)-1)^1<16)*(RIGHT(Interventi
ons!C19:C81,1)="M"),1,))
etc, depending on what's supposed to happen with ages like 5.5, 15.5, and so
on.

Cheers


"santaviga" wrote in message
...
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

I have cells with headings Male 0-5 6-15 16-30 30-70 70+ the same for
female
and age ranges these are against medicines.

So e.g. I want to input 56M into a cell I want this to count up into cell
labeled Male 30-70 and so on, keep counting the number of times ranges are
entered to M or F the same if I enter 74F I want this to count in the cell
labelled Female 70+.

Hope you can understand this, thanks for the HELP!!!!!


Can anyone HELP!!!!!!!! Its doing my head in...

Thanks