I need to count cells if a different cell contains text

[ahalliwell]

So...

I'm new here this is my first post, so Hello everyone! hopefully you can help

I have a spread sheet and I need to do the following:

IF Cell D8 contains "Acc"
then
COUNT Cells E8:L8 IF they contain the word "Pass"

The reason I am doing this is I work within a quality assurance department and I have Acc(accreditation) and BAU(Business as usual) checks, I need to calculate the % of Accreditation passes and the % of BAU passes but every time I try and do a formula I think will work it never happens.

Please tell me someone can help?

[EchoPassenger]

=IF(D8="Acc",COUNTIF(E8:L8,"Pass"),"")

[avk]

Also try as per below.
ACC_AVK.JPG

[JohnTopley]

@AVK: please post your formulae (and sample workbook if appropriate) NOT images.

[avk]

@AVK: please post your formulae (and sample workbook if appropriate) NOT images.

Formula's as per below. Also attach sample file.
In "A2" :

Please Login or Register  to view this content.

In "B2" :

Please Login or Register  to view this content.

In "C2" :

=COUNTA(G2:N2)

In "D2" :

=IF($F2=$F2,COUNTIF($G2:$N2,D$1),"")

In "E2" :

=IF($F2=$F2,COUNTIF($G2:$N2,E$1),"")

From "F2" to ""N2" Data record

[ahalliwell]

Brilliant all your ideas were really helpful using your input I have managed to solve the issue! thank you very much!

[avk]

Dear Ahalliwell : If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".