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"))




-- 
Mick Bonser - newbold

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

"Mick Bonser - newbold" <Mick.Bonser.-.newbold.59e1090@excelbanter.com> 
wrote in message news:Mick.Bonser.-.newbold.59e1090@excelbanter.com...
>
> 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"))
>
>
>
>
> -- 
> Mick Bonser - newbold