Count If

[Mr B G]

Hi all,

Looking for some help with a formula please.

I need to count Y's in column on one sheet and put the total on another sheet.

Example: If column G equals London and column L equals Yes count.

I need that count total on another sheet called "sheet 2".

Any help please!??

 

[VoG]

Try

=SUMPRODUCT(--(Sheet1!G1:G100="London"),--(Sheet1!L1:L100="Yes"))

 

[Mr B G]

Brilliant, thanks for the quick response, I'll give it a go.

 

[Mr B G]

That is exactly what I was after, thank you.

One more, how can I add Y as well as yes?

 

[VoG]

Try

=SUMPRODUCT(--(Sheet1!G1:G100="London"),--ISNUMBER(MATCH(Sheet1!L1:L100,{"Yes","Y"},0)))

 

[Mr B G]

That's the one, thank for your help :D