COUNTIF Formula in a Table

Originally Posted by benishiryo

welcome to the forum. right choice to upload the sample excel file as well. would be also nice to manually key in the answers you wish to see & explain at least how you got 1 of them. my guess is this in I5:
=SUMPRODUCT(($A$5:$A$26=I$4)*($B$5:$E$26=$H5))

copy down & across

Thanks for that. It has worked and is adding up across the rows!

Really appreciate your help.