I am having difficulty understanding.
There is no data in column G.
Cell B or cell G. There are columns B and G.
That said:
I take it that you want a formula in cell A3 that sums column F if the project number in column B equals the project number manually input into cell A2.
If that is correct try this formula in cell A3
I am not clear on this part.
I want to add Cell F - "total of refunded amount". Enabling Cell G "remaining amount" (of "total softfunding granted") to be continously updated (when reached 0 the 'project' is complete"
Cell B has a project number of a company. I need to check if the same company/project number has recieved refunds before. If so, the amount refunded in cell(s) D needs to be summerize to a total amount in F.
The only headers I see referencing "Refund" are above columns C and E and there are no values in column E.
Bookmarks