Using an element of an array as criteria for SumIfs

**austincg1** · 08-18-2015, 10:55 AM

I have an array, which represents a list of criteria that I want to sum a column of a table by.

Formula:

Please Login or Register  to view this content.

For some reason, that SumIfs says Application-defined or Object-defined error. I am positive that T_data2 is a table that exists. That table DOES have Total Weight and Customer columns. What am I doing wrong?

Thank you for the help!

**berlan** · 08-18-2015, 11:01 AM

Can be written more efficient without using Selection, but the problem here lies in how you are using myCustomers(i) for the formula output.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**austincg1** · 08-18-2015, 11:09 AM

Yeah, I'm sure my code is incredibly inefficient. I'm pretty new :P

I just tried that, both with single and double quotes. Neither worked :/

Still runtime error 1004: Application-defined or Object-defined error..

Using an element of an array as criteria for SumIfs

LinkBack

Thread Tools

Rate This Thread

Display

Using an element of an array as criteria for SumIfs

Re: Using an element of an array as criteria for SumIfs

Re: Using an element of an array as criteria for SumIfs

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] SUMIFS formula that takes first seven of matching criteria from an array

[SOLVED] SUMIFS/COUNTIFS array function question (multiple criteria)

[SOLVED] SUMIF or SUMIFS with Array Criteria

Reading in text file into array. Each element is a line of file. Why last element a space

[SOLVED] SUMIFS with multiple criteria evaluated against array?

[SOLVED] SUMIFS to match array of Criteria

Help using a list/array as criteria in SUM(SUMIFS())

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions