Reputation: 177
using google sheets I have the following formulae :
=CONCAT( SUMIFS($H$3:$H$39,$C$3:$C$39,C3,$E$3:$E$39,"SELL"),C3)
Now I want to improve this formulae, instead of concatenating the the same cell, I would like the value of the first part SUMIFS and the value of C3 to be placed in two contingents cells.
Upvotes: 0
Views: 35