Help with countifs statement if that's what I should be using???=COUNTIFS(Bramshaw!C3:N3,I1,Lulworth!C3:N3,I1)for Bramshaw the number relating to I1 is 3 and Lulworth I1 is 1.When I enter the formula i get an answer of 1 rather than 4? Am I using the correct formula to add them together...