SUMIF problems in Excel for Windows XP

D

Dliu228

Has anybody encountered an issue with the SUMIF function in Excel for
those with Windows XP?

It appears that there is a limit to the size of the range you want to
perform the SUMIF function. Any advice or comments are greatly
appreciated. Thanks !!
 
J

J.E. McGimpsey

Rather than being coy, what problem are you seeing with what size
range?

I just tried =SUMIF(A:J,">0",A:J)

(655,360 cells) with no problem.
 

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

sumif issues 1
Limitations on Sumif Calculation 3
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
subtotal with sumif nested 1
Sumif apllying to all sheets in workbook 2
Help with determining instructor class location. 0
Convert/rewrite SUMIFS formula to work in Excel 97 3
SUMIFS and OR 6

Top