H Lookup with a Sum Product Function

[Anitykk]

I have a spreadsheet in which ocassionally, an extra row is added that causes an issue with my current formula (=SUMPRODUCT(($Z$19:$Z$230>0)*$Z$19:$Z$230). In this case the row that I want to calculate will change from 19 to 20; I thought I could use an H Lookup formula combined with my SumProduct to correct my issue but have been unable to successfully do so.

Any help would be greatly appreciated

 

[Fotis1991]

Cross post Combing H Lookup and SumProduct

 

[Anitykk]

Sorry, it has taken me so long to respond and thank you for your time. I am unfamiliar with cross posting. Can you give me a crash course?

 

[VoG]

Sorry, it has taken me so long to respond and thank you for your time. I am unfamiliar with cross posting. Can you give me a crash course?

Please read Excelguru Help Site - A message to forum cross posters