Sum Product Formulae

[midfieldgeneral11]

Commercial Status
Signed	Committed
Signed Waiting to be Scheduled	Committed
Approved	Committed
Awaiting Approval	Pipeline
At Risk Awaiting Approval	Committed
In Draft	Pipeline
Ongoing Discussions	Pipeline
SoW is with Cient	Pipeline
With AM	Pipeline
Tantalus Project Delivery	Committed
R21 Broking & Origin Delivery	Committed
With Technical Team	Committed

Then above is a table I have in a tab called lookup

The spreadsheet has 400 lines and have been assigned an Commercial status to each item.

Hello hope you can help. I have two columns with Days (A) and revenue numbers (B)
Column C has one of the above Commercial Status item assigned.

Like to have a formulae which states the following

If the status = Committed then to sum the total in column D as a Committed Value
If the status = Blank then sum the total in Column E which are Pipeline then sum this as Pipeline.

With this I am able to then simply add a pivot table to simply see the split of Committed and Pipeline.

Can you help?

S

 

[awoohaw]

@midfieldgeneral11
Can you post sheet that you want worked on as an xl2bb add in mini sheet (link below).

What do you mean by day? Is it a date or a weekday name?

Also, please update your profile so your thread button shows what version(S) of excel you use.
And if multiple versions, please tell us in thread which version you are using in this scenario.