adding the results of 2 sheets

  • Thread starter Thread starter aboiy
  • Start date Start date
A

aboiy

Good day to all,

Is it possible to merge these 2 formulas into 1 cell so
that resulting figure will be displayed only in 1 column.

=SUMIF(RS!$F$24:$F$38,'Supplier-Acct'!$B55,RS!
$G$24:$G$38)

=SUMIF(Stock!$F$24:$F$38,'Supplier-Acct'!$B55,Stock!
$G$24:$G$38)

For your kind assistance.

Thanks and regards.

aboiy
 
Hi Aboiy!

Use:

=SUMIF(RS!$F$24:$F$38,'Supplier-Acct'!$B55,RS!$G$24:$G$38)&"
"&SUMIF(Stock!$F$24:$F$38,'Supplier-Acct'!$B55,Stock!$G$24:$G$38)

I've assumed that you want a space between results.
 
Since the request stated <<"resulting figure">> (singular), perhaps
&" "&
should be replaced with a simple
+
 
Hi RD!

You're probably right. Complete misread. Looking for something more
difficult.
 
Would sure like to know if you were looking for a single "summed" number, or
two separate numbers displayed in the cell.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Norman & RD,

Thank you to both you, really its a
big help for me.

Regards,

aboiy
 
Hi RD,

Im after for a single result from two these two different
sheets.

Regards,

aboiy


-----Original Message-----
Would sure like to know if you were looking for a single "summed" number, or
two separate numbers displayed in the cell.
--


Regards,

RD
---------------------------------------------------------- ----------
Please keep all correspondence within the Group, so all may benefit!
---------------------------------------------------------- ---------


Norman & RD,

Thank you to both you, really its a
big help for me.

Regards,

aboiy



-----Original Message-----
Since the request stated <<"resulting figure">> (singular), perhaps
&" "&
should be replaced with a simple
+

--
Regards,

RD

---------------------------------------------------------
Click to expand...
- -
.
Click to expand...
 
Hi aboiy!

Then you want:

=SUMIF(RS!$F$24:$F$38,'Supplier-Acct'!$B55,RS!$G$24:$G$38)+SUMIF(Stock!$F$24:$F$38,'Supplier-Acct'!$B55,Stock!$G$24:$G$38)
 
Hi Aboiy!

No problem!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
 
Back
Top