Counting

[medinno]

Hi ,

I have attached a sample sheet . The table in Yellow is the input data . The figures in the table in read are the desired figures . How can i get the table in red using formulas .

[Special-K]

in E2
=COUNTIFS($A$2:$A$11,E$1,$B$2:$B$11,$D2)
copy across and down

[medinno]

Thanks a lot . Did not know about the countifs function .