ziwdig44bugs
ziwdig44bugs

Reputation: 177

How to split result in tow cells

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

Answers (1)

player0
player0

Reputation: 1

try:

={SUMIFS($H$3:$H$39, $C$3:$C$39, C3, $E$3:$E$39, "SELL"), C3}

Upvotes: 2

Related Questions