Novice
Novice

Reputation: 393

Excel database formula

Have more then 200k rows and want sort it via multiple criterias. COUNTIF works perfectly but at the end waiting minutes for simple changes becouse there is more then 1500 formulas.

So i desided for database formulas, but have a problem with criteria headers.

simple example:

enter image description here

How i can use same crtiteria table without January row ? for me is only way hot to do that is create criteria with headers again:

enter image description here

Is there any way how can have one criteria table with multiple rows and using only rows what needed ?

Upvotes: 0

Views: 35

Answers (1)

user11217663
user11217663

Reputation:

Subtract a growing total of DSUMS above the current row.

=DSUM(A$2:B$11, D$2, C$2:C3)-SUM(D$2:D2)

enter image description here

Upvotes: 2

Related Questions