Formula trouble

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Hi guys,

I recieved help from one ouy yesterday regarding summing
up the number of "F" and "M" (for male and female). The
formula is as follows:
"M = "&TEXT(COUNTIF(E3:E352,"m"),"0") or using F for
female. The problem I now have is unlike the other
formulas, if I insert a row to make it 353 instead of 352
rows, it wont add it automatically and update the formula
automatically. Any idea why ?
 
Hi
if you insert a row in between it should change
automatically. If you just add another row at the bottom
the formula won't change.
 
Hi,

So you are saying that if I mwnt to add more rows as I
update this databaseI have to leave a blank row between my
data and the totals? I need to be able to explain this to
an older woman who will be using this later and isnt that
familiar with computers.
 
Why not use ="M = "&TEXT(COUNTIF(E3:E5000,"m"),"0")
Now you can add data as needed without inserting

best wishes
 
Back
Top