samir_aguiar
New Member
- Joined
- May 6, 2011
- Messages
- 16
Hello,
I have a cell with the following formula:
=SUMIF(D4:D12,">0",E4:E12) & "/" & SUM(E4:E12)
So its output is 10/20, 15/23 etc...
Needed to use the first value in another cell, can I extract that value?
I mean, I have another cell which would use only this part:
SUMIF(D4:D12,">0",E4:E12)
Do I have to type it again or is there an way to extract that?
Thanks in advance.
I have a cell with the following formula:
=SUMIF(D4:D12,">0",E4:E12) & "/" & SUM(E4:E12)
So its output is 10/20, 15/23 etc...
Needed to use the first value in another cell, can I extract that value?
I mean, I have another cell which would use only this part:
SUMIF(D4:D12,">0",E4:E12)
Do I have to type it again or is there an way to extract that?
Thanks in advance.
Last edited: