ExcelBanter - how can i use SUMPRODUCT with a non-contiguous set of cells?

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

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

- - how can i use SUMPRODUCT with a non-contiguous set of cells? (https://www.excelbanter.com/excel-discussion-misc-queries/25364-how-can-i-use-sumproduct-non-contiguous-set-cells.html)

Wade Wilson

how can i use SUMPRODUCT with a non-contiguous set of cells?

Chip Pearson

You can't.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Wade Wilson" <Wade wrote in
message
...

All times are GMT +1. The time now is 09:32 AM.