Help with sum, product and aggregate function

Hi,

I would ask for a little help. I would need a function that would sum and product numbers if the required data is inserted, and if data is partial it would return blank field. I tried aggregate function and did not do well because if i have etc. 4 data in original and in row only 3 data it sums that 3 that shuld be blank. I have a attached a workbook below for better understanding. Thank you
Bs

Hi, this does not work well. It gets almost all calculation wrong. Please see atached woorkbook for details

I solved the problem. Thank you for help