count a number range and a letter in a cell
Hi Ron,
This is returning a Value...
M
"Ron Coderre" wrote:
Perhaps something like this:
With values in A1:A10 on Sheet1
where some cells may be blank
On Sheet2
A1:
=SUMPRODUCT((RIGHT(Sheet1!A1:A10,1)="F")*(--(LEFT("0"&Sheet1!A1:A10,3))=39)*(--(LEFT("0"&Sheet1!A1:A10,3))<=60))
Note: in case of text wrapping, there are no spaces in that formula
That formula counts the number entries between 39-60 that end in "F"
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP-Pro
"santaviga" wrote:
Anyone help? I need to have a running total of numbers and text in the same
cell onto another sheet and cell. e.g 74M, 80M will total in a cell Male 70+.
56F, 40F will total in a cell Female 39-60, any ideas for a formula for this,
I can get the cell to recognise the ages, also recognise whether text is M or
F but cant get the cell to recognise both as text 74M. info in cell is input
as AGE then sex. e.g 76M, 50F
|