adding the results of 2 sheets

[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

 

[Norman Harker]

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.

 

[Ragdyer]

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

 

[Norman Harker]

Hi RD!

You're probably right. Complete misread. Looking for something more
difficult.

 

[aboiy]

Norman & RD,

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

Regards,

aboiy

 

[RagDyer]

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

 

[Guest]

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

---------------------------------------------------------

- -
.

 

[Norman Harker]

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)

 

[Aboiy]

Norman,

Once again thank you for helping me out.

Regards,

aboiy

 

[Norman Harker]

Hi Aboiy!

No problem!

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