Count Values matching row and column criteria

[Arun Mani A]

Hi,

I am doing a report where I have various types of windows for nos of flats in different levels. And the sample of the data is attached here with.

Help me out with formula for counting the nos of windows in particular level.

Thanks in advance

Regards

Arun

 

[bosco_yip]

Try........

In E16, formula copy across to G16, and all copy down :

=SUMPRODUCT(($A$3:$A$11=E$15)*($B$3:$J$11=$D16))

Regards
Bosco

 

[fredieusa]

The formula for your cell E16 to get "2" will be
=COUNTIF(B3:J5,D16)

This formiula will look for "SD-01" in all 3 rows that read Level 1
B3:J5 is the range, where it looks for.
D16 is SD-01, type of window.

 

[Arun Mani A]

Very a Thanks Bosco. It Worked !!!