If identical value excist in colonne B, summeries values in colonne D into colonne F
I want to add a function in colonne F:
1. Use value in associated cell B to check if any other cell in colonne B is identical to cell B.
If so,
2. Use the associated cell(s) in colonne G and summaries these in cell F.
More details:
The sheet contains information about:
Cell A and C is date and project name.
Cell B: "Project number"
Cell E: "total softfunding granted"
Cell D: "refunded amount"
Cell G: "remaining amount".
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.
Seems like it should be a function if, but I need help.
Re: If identical value excist in colonne B, summeries values in colonne D into colonne F
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.
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.
Last edited by FlameRetired; 01-23-2019 at 07:32 PM.
Reason: additional thought
Bookmarks