count values in range based on value in same row

  • Thread starter Thread starter Mick Bonser - newbold
  • Start date Start date
M

Mick Bonser - newbold

To save time adding additional copies of the data to the individual
spreadsheet is there a way of combining this formula ?

=IF($e3="Male",Q3,"") for example

I have used this 'Master Sheet'!E3="Male", but I realise that as the
row changes this reference would not change. Does anyone know how I
could amend / replace this formula to give the required result

=IF('Master Sheet'!E3="Male",COUNTIF('Master Sheet'!Y3:Y203,">=31"))
 
Add a defined name (Insert>Name>Define...) or the current E3 cell and use
that in the formula

=IF(Mastefield",COUNTIF('Master Sheet'!Y3:Y203,">=31"))

HTH

Bob
 
Back
Top