Combine Vlookup and Countif...I need help please!!!

[butterboxbaby14]

Hi,

I would like to get assistance on the attached sheet. I am trying to get the number of Y's and N's per Country and be displayed in the Summary tab.

I hope someone can help me on this. Been trying several and can't seem to get it running.

Thanks.

 

[Somendra Misra]

Hi,

Do you want to add both column Y and N against one country?

For eg: South Africa --> Total Y in column D is 11 and in column E is 9. So in Summary Sheet against South Africa you want 20 as result in Y?

Regards,

 

[butterboxbaby14]

Hi,

Do you want to add both column Y and N against one country?

For eg: South Africa --> Total Y in column D is 11 and in column E is 9. So in Summary Sheet against South Africa you want 20 as result in Y?

Regards,

Well I intend to count the Y's and N's in Column D and then do the same for column E. If you show me how you do it for column D for now, I can study and do it myself for the rest

 

[Ateeb Ali]

Please see attached sheet, its simple formula "countifs"
Press like button if job done

 

[butterboxbaby14]

Please see attached sheet, its simple formula "countifs"
Press like button if job done

Thank you so much.

 

[butterboxbaby14]

Just a quck question to add. If I would want to have the Raw Data act as a database wherein continuous data is being added to the sheet(so row number increases), is there a way to have the formula recognize the whole column instead of just what is currently in it?

 

[butterboxbaby14]

Please see attached sheet, its simple formula "countifs"
Press like button if job done

Just a quick question to add. If I would want to have the Raw Data act as a database wherein continuous data is being added to the sheet(so row number increases), is there a way to have the formula recognize the whole column instead of just what is currently in it?