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

[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?

 

[Andy B]

Hi

Try this:
=SUMPRODUCT((C7:C17=1)*(F7:F17="P"))

 

[rca_swisher]

-----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

the following
=COUNTIF(F7:F17,"P")+ COUNTIF(F7:F17,"F")

 

[Guest]

Sumproduct worked beautifully. Thanks

-----Original Message-----
Hi

Try this:
=SUMPRODUCT((C7:C17=1)*(F7:F17="P"))

--
Andy.





.