Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sumif{array}

Status
Not open for further replies.
mllex

mllex

Technical User
Nov 28, 2001
44
US
Has anyone run into problems with sumif{arrays} formulas returning #NA if the data range you are referencing is too large? If so, how did you work around it? I have about 1,000 rows of data and I am getting inconsistent results.

Many thanks.


 
Sort by date Sort by votes

Can you post your equation and give us a brief explanation of your data so we can dive into this a little better?

The only issue I've ever had with array formulas is they can be slow if the range is very large (many thousands of cells) and some stuff won't work if you use an entire row or column (1:1 or D:D).
 
Upvote 0 Downvote
And I've returned #NAs before when the IF range wasn't the same size as the SUM range.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
525
Andrzejek
Andrzejek
pendle666
  • Locked
  • Question
Excel 365 - Multiple SUMIFs with percentages
Replies
5
Views
518
combo
combo
BxWill
  • Locked
  • Question
MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working 3
Replies
10
Views
468
BxWill
BxWill
Igawa29
  • Locked
  • Question
Excel SUMIF and ISERROR 2
Replies
5
Views
308
SkipVought
S
03Explorer
  • Locked
  • Question
Access VBA FORM: Sub has Array which I want to use in Module:Sub
Replies
2
Views
189
03Explorer
03Explorer

Part and Inventory Search

Sponsor

Back
Top