Fornula needed: Count cells is adjacent cell contains or equals to specific word

Originally Posted by Vikas_Gautam

Hi
welcome to this forum
Check the attached file..

Sorry, still trying to get used to the forum and how to post things, but there is my issue:

in my case, "Check total:" and the amount are not necessarily aligned, meaning that “Check total:” and the amount are not always in the same column.

for one of the checks, “Check total:” is in cell B2 and amount in B3, for another check, “Check total:” is in cell F4 and amount is in cell F5.

I also have rows in-between with additional information of the check that I am not using.

Is there anything that can be done in this case?