Counting with multiple criteria in multiple columns

[1609em]

For Example : In column G the values 21F, 23, 10F, 45 exist and i
column D the values P, C , T exist. I need a formula to count if colum
G has 21f and 45 AND column D has a P in it.

G D

21F P
23 P
10F C
45 P


So i need something to show that there are 2 of this combination

 

[Vacuum Sealed]

For Example : In column G the values 21F, 23, 10F, 45 exist and in
column D the values P, C , T exist. I need a formula to count if column
G has 21f and 45 AND column D has a P in it.

G D

21F P
23 P
10F C
45 P


So i need something to show that there are 2 of this combination.

Hi

Try this

=SUMPRODUCT(($D$2:$D$10000="P")*($G$2:$G$10000="21F")+(($D$2:$D$10000="P")*($G$2:$G$10000=45)))

This formula assumes the 1st row is the header, you can adjust the range
to suit.

HTH
Mick.