If identical value excist in colonne B, summeries values in colonne D into colonne F

Hello Tinemaurstad. Welcome to the forum.

Try this:

Formula:

Please Login or Register  to view this content.

If that does not do what you want please upload a sample Excel workbook of the data you are working with.

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

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

Formula:

Please Login or Register  to view this content.

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.

You are welcome.