Hello - I have an existing concat function like below:
=CONCAT(SUM(X6,X14), " (", ROUND(SUM(X6,X14)/SUM(W6,W14),2)*100,"%)")
Firstly, I want to understand what the above formula is doing.
Secondly, I want to achieve with only X6 and W6.. meaning i do not want to SUM with X14 and W14. How do I achieve this?
This is a bit urgent request. Hope someone helps me in time.
Thank you.
Bookmarks