SUMIF problems in Excel for Windows XP

  • Thread starter Thread starter Dliu228
  • Start date Start date
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 !!
 
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.
 
You must log in or register to reply here.

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

Limitations on Sumif Calculation 3
SUMIF ERROR 3
SUMIF Function 2
SUMIF on a Calculated Field 3
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
sumifs, sumif with dates 6
subtotal with sumif nested 1
nesting sumif functions 5

Back
Top