ExcelBanter - sumifs

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - sumifs (https://www.excelbanter.com/excel-programming/408706-sumifs.html)

Cresta

sumifs

Hello
Can the sum_range be wider than 1 column (or row)?

sumifs("a1:a100", ...... works ok

sumifs("a1:z100", ...... gives #value

Any ideas
Thanks

ryguy7272

sumifs

use a Pivot Table

Regards,
Ryan--

--
RyGuy

"Cresta" wrote:

Hello
Can the sum_range be wider than 1 column (or row)?

sumifs("a1:a100", ...... works ok

sumifs("a1:z100", ...... gives #value

Any ideas
Thanks

All times are GMT +1. The time now is 02:59 AM.