sumifs

C

Cresta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria 4
SUMIFS with relative reference r1c1 3
How do I use sumifs - 1
SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria 1
Create range in udf 1
Filtering with SUMIFS 1
simple sumIfs question 1
SUMIF and SUMIFS Error 3

Top