# excel Help

#### olibooth

##### New Member
hi all.

ive been trying all day and struggling. I have a spreadsheet for work audits. I have them set up in month order and the cell gets either a P,A or F in it.
ive been to count how many P,A and F there are in each month and add up as it goes.

ive managed to turn the letter it in a number with this formula:
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(ISNUMBER(SEARCH("p",G3)),1,"")
but that's only work on one cell, I need it to do this over 6 cells.[/FONT]

Any help would be great.

thanks

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### jtakw

##### Well-known Member
Hi,

Not entirely sure what End result you're looking for, a Total of P, A, or F individually or combined?

But look into the COUNTIF or COUNTIFS function.

#### olibooth

##### New Member

i'll set the scene to try and help.
each engineer gets upto 6 audits a month. each one of them can be a Pass, Advisory or Fail. which i enter in manually.
i have a summary page that i need to know how many Pass, Advisory or Fails the engineer has had for the year.

hope that makes sense

#### jtakw

##### Well-known Member
Again, look into the COUNTIF or COUNTIFS function, but depending on how your data is setup, which you haven't given any sample, you might need SUMPRODUCT.

This is a sample using COUNTIF:

Book1
ABCDEFGHIJK
Sheet526
Cell Formulas
RangeFormula
I2=COUNTIF(\$B2:\$G2,I\$1)

I2 formula copied down and across to K2

#### olibooth

##### New Member
thank you so much, this has worked a treat.

think i was over complicating it to much by trying to turn the letter into numbers first.

#### jtakw

##### Well-known Member
You're welcome, welcome to the forum.

Just post back if you need further assistance.

Replies
1
Views
235
Replies
1
Views
285
Replies
0
Views
358
Replies
3
Views
202
Replies
0
Views
625

1,195,904
Messages
6,012,212
Members
441,682
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back