Speed up =sumif(A:A,A:A,B:B) ?
Posted on 2013-06-03
Very quickly gets very slow.
What ways are there to tell it not to add up one million rows (or whatever)?
Typically the business use involves a very few thousand rows, tops. Usually 1 or 2 thousand only.
Purpose is balances by (accounting) reference.
I plan to make it a named formula, so any array type solutions also welcome.
I am trying to avoid A1:A1000 as a solution.