Hello,
In the attached Excel sheet there's an overview of different products with different prices.
Some of them are a one-time cost and the other ones are recurring costs.
Is it possible to create an IF formula (or a different formula) that automatically checks this for me?
In column O (total sum) there's the total sum count. Then in column P (One time) I would like the total sum of the one-time cost.
And in column Q (Recurring) I would like the total sum of all recurring cost.
On first tab 'Impress' you can find the wanted result in cell P2 en Q3.
If possible please make a formula that automatically generates this per rule.
On the second tab 'Complete item list' there's an table which defines what products are 'One time cost' and which ones are recurring.
Thanks in advance!
~
Bookmarks