help counting cells of a particular category

E

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

cincode5

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

cincode5

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

Domenic

Hi,

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

=SUMPRODUCT((D2:D6=3)*(E2:E6=2))

Hope this helps!
 
Top