Zhead wrote:
In coloumn A some cells contain "Y" coloumn F also has cells that contain a
"Y" i would like to know how to sum which same rows in A and F contain "Y"

Try:

=SUMPRODUCT(--(A:A="Y"),--(F:F="Y"))