help counting cells of a particular category

[excel challenged]

I am trying to add up a certain number of cells however,
I keep getting a different number than that counted
manually. for example:
size species flight dir xing react zne
2 shc w 2 3
2 shc w 2 2
2 shc w 2 2
2 shc w 2 3
2 shc w 2 3
I'm trying to determine the number of cells that are at a
xing height of 3 and a reaction zone of 2 and I keep
getting a different number for the countif function than
i do manually (i would stick to the manual stuff, but I
have thousands of entries)

 

[Guest]

You might want to define a new IF cell for each row that looks at the values of 'xing' & 'react zne'. For example:
=IF(xing=1,IF(react zne=2,1,0),0)
A return value of 1 will indicate the perametures you are looking for, and zero a miss. Then simply SUM the column for the exact number.

 

[Guest]

Sorry... I cut and pasted from an actual cell formula and didnt change the values. It should look like this
=IF(xing=2,IF(react zne=3,1,0),0)

 

[Domenic]

Hi,

Assuming that your headings are in the first row and that your table
starts at A2, try:

=SUMPRODUCT((D26=3)*(E2:E6=2))

Hope this helps!