excel formula - its urgent

Hi friends,

I need help on a formula in which i want to count the text in a column if a particular criteria is fulfilled in another column. For example,   the data is as given below:

Name                    yes/no

nitin                       yes

sanjeev                no

sanjeev                yes

nitin                       yes

nitin                       no

now i want a formula in which the result should be total number of yes from yes/no column if there is nitin in name column i.e., nitin = 2, sanjeev = 1.

Please suggest the formula.

Thanks in advance.

Replies (5)

u can use pivot table......

with Names as row labels

Yes/No as column labels

&Yes/No(count) as values

Thank you.

=COUNTIFS() can be used if you are using MS Excel 2007 onwards

www.excelnext.in

You can use Countif  as per atteched sheet

 

Anand

9891086214

Hi,

You can use 'COUNTIFS' FUNCTION where you can add multiple condition.

This function is available in 2007 version of excel.

 

Nitin

Yes

Sanjeev

Yes

Sanjeev

No

Nitin

Yes

Nitin

No

2

=COUNTIFS(A1:A5,"Nitin",B1:B5,"yes")

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details