Hello,




I hope that everyone out there is well.


If this is possible and someone is kind enough to help me, it will be GREATLY appreciated. I would like to try and make this work with my current layout on the "Log" tab.


So, on the "Summary" page, I want to be able to sum the dollar amount from the "Log" tab in column F for each phase when it gets approved. So, by the time everything is approved through all of the phases would amount to $54,465.



I gave an example that I manually calculated on the "Summary" page in column D.


I hope that I am explaining this fully and someone out there can help.


Thank you in advance.

Attached Files

Phases.xlsx (13.9 KB, 9 views)

This method uses HELPER columns and formulas :

Attached Files

Phases.xlsx (15.4 KB, 9 views)

One simple formula per row and no helper columns:

Attached Files

Phases.xlsx (13.8 KB, 13 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you Logit & Macropod for your generous help. Both methods are great to know. You help is greatly appreciated .

Glad to help.

How would the formula need to be altered if I changed column Q to a 10-digit number? See Phases2.xlsx attached.



Your help is greatly appreciated.

Attached Files

Phases2.xlsx (14.1 KB, 6 views)

As was done with column D, use: =SUMPRODUCT((Log!Q2:Q12>0)*1,Log!F2:F12)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Another solution

Attached Files

Phases.xlsx (15.6 KB, 7 views)

Thank you very much ArviLaanemets!