ExcelBanter - Sumproduct and Countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumproduct and Countif (https://www.excelbanter.com/excel-discussion-misc-queries/137504-sumproduct-countif.html)

Sumproduct and Countif

Please help, I'm going round in circles.

i need to creat a formula for the follow

1 x

All times are GMT +1. The time now is 09:25 PM.