Count, sum, count if, sum if ...confused

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have cells b7-17 with numbers 1-3 and cells d7-17 with
either a P or an F. What I want to do is tally all the
numbers with a P in f7-17 and like wise with F in g7-17
Have tried:
=COUNT(IF(C7:C17="1",AND (IF(E7:E17="P",1,0))))

=SUM(IF(C7:C32="1",IF(E7:E32="P",1,0)))

=COUNTIF(C7:C31,1)*AND(E7:E31,"P")

None work the 2nd one was from MS Help but did not
work.Any suggestions?
 
-----Original Message-----
I have cells b7-17 with numbers 1-3 and cells d7-17 with
either a P or an F. What I want to do is tally all the
numbers with a P in f7-17 and like wise with F in g7-17
Have tried:
=COUNT(IF(C7:C17="1",AND (IF(E7:E17="P",1,0))))

=SUM(IF(C7:C32="1",IF(E7:E32="P",1,0)))

=COUNTIF(C7:C31,1)*AND(E7:E31,"P")

None work the 2nd one was from MS Help but did not
work.Any suggestions?
.
If your wanting a total of the P's and the F's using
Click to expand...
the following
=COUNTIF(F7:F17,"P")+ COUNTIF(F7:F17,"F")
 
Back
Top