Help with countifs statement if that's what I should be using???

[russellday]

[COLOR=rgba(0, 0, 0, 0.9)]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? [/COLOR]hashtag#help[COLOR=rgba(0, 0, 0, 0.9)] [/COLOR]hashtag#formula

 

[FormR]

Am I using the correct formula to add them together?

No - I don't think so, you would need to do something more like this:

=COUNTIFS(Bramshaw!C3:N3,I1)+COUNTIFS(Lulworth!C3:N3,I1)

 

[Special-K99]

What you've defined is a COUNTIFS where ALL the conditions are true.
FormR's reply has defined an OR where at least one of the conditions are true.
But as you haven't defined what you're counting for it's impossible to say.