Formula for running total

S

santaviga

I need a formula to the following. 74M, 70M, 86M. a formula to recognise the
number and text of the cell and get a total from another cell which has a
total of the following Male age 70+ (3), I can get the formula to recognise
the numbers and the letter seperately but cant get a formula to recognise
both to put them in proper cells for age male, age female.

The formula i'm using is the following =COUNTIF(Interventions!C19:C81,">70")
I need to integrate M or F into this to list Male and Female over 70.

Can anyone help me????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Formula 3
count a number range and a letter in a cell 3
Lookup values if Value 1 is x or y and Value 2 is a,b,c,d. 3
code to copy range 1
SUMPRODUCT question 3
Multiple IF function 5
HELP!!!! on formula PLEASE!!!!!!!!!!!! 11
Using COUNTIF for multiple text data creating a logic statment 12

Top