ExcelBanter - Sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumproduct (https://www.excelbanter.com/excel-discussion-misc-queries/143390-sumproduct.html)

Tim Elhatton

Sumproduct

Hi there,

Can I use sumproduct in one spreadsheet, and reference or evaluate cells in
a completely different spreadsheet?

Thanks

Dave Peterson

Sumproduct

Sure.

Tim Elhatton wrote:

Hi there,

Can I use sumproduct in one spreadsheet, and reference or evaluate cells in
a completely different spreadsheet?

Thanks

--

Dave Peterson

T. Valko

Sumproduct

Do you mean 2 separate *files* ?

Generally, yes, but it depends.

Biff

"Tim Elhatton" wrote in message
...
Hi there,

Can I use sumproduct in one spreadsheet, and reference or evaluate cells
in
a completely different spreadsheet?

Thanks

All times are GMT +1. The time now is 01:53 PM.