Solved: COUNTIFS Formula not working in Excel 2007

[Skopweb]

Hi,
I'm trying to use the formula of countifs. However, i get the error "#VALUE".
Not sure what is wrong. attached is the sheet and the formula is

=COUNTIFS(Nm_id,G$14,At_ID,$F15)

Can someone help?

[Paul_Hossler]

I think you want this in G15, and then fill to the yellow cells

I get 1 S1, 29 S2's, and 1 S3 for Region 1


=COUNTIF(B:B,$F15)


Paul

[Aflatoon]

If you really want to match the headers, then:
=COUNTIF(INDEX($B:$D,0,MATCH(G$14,Nm_id,0)),$F15)