sumproduct with multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top