sumproduct with multiple criteria

G

Guest

Hi I need to create a formula that will sum based on multiple criteira. I am using a sumproduct formula (thank you Frank :) ) and it works well adding one period of data and now i need it to add three periods

I have
=SUMPRODUCT(--(ModifiedAcctNum=$B13),--(PeriodIDColumn=1),PeriodBalanceColumn

Modified Account Num Period Balance Period I

900 5
901 5
902 5
900 5
900 5

I need
=SUMPRODUCT(--(ModifiedAcctNum=$B13),--(PeriodIDColumn=1+2+3),PeriodBalanceColumn

Any ideas

Tod
 
J

JE McGimpsey

One way:


=SUMPRODUCT(--(ModifiedAcctNum=$B13), --(PeriodIDColumn>=1),
--(PeriodIDColumn<=3), PeriodBalanceColumn)

Though if you're starting to do multiple periods, you should really look
into creating a Pivot Table.
 

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

sumproduct with multiple variables 8
sumproduct with unhidden data 1
Sumproduct/match problem 2
Sum on multiple columns with search criteria 6
Sumproduct formula 6
Sumproduct Lookup with multiple critera? 2
SUMPRODUCT 2
Sumproduct with more than one valid criteria 1

Top