Modifying an Already Written Function

[saxophonemaster]

I have a function that I have been using in one of my excel spreadsheets and need help on figuring out how to modify it. I'm sure macros would be easier, but I haven't gotten around to learning those yet.

Right now, the formula looks like
=-1*SUMPRODUCT(--('Transaction List'!$B46:$B595>="5/22/2011"+0),--('Transaction List'!$B46:$B595<="5/26/2011"+0),--('Transaction List'!$E46:$E595="Transportation"),'Transaction List'!$G46:$G595)

This basically pulls transactions from a different sheet that fall between the two dates and have the certain category.

What I want to add is another condition where it will pull the information if it matches two different account names.

If the account names are in say column C, and I just wanted to pull it if it matched one account in addition to the previous requirements I know I could do

=-1*SUMPRODUCT(--('Transaction List'!$B46:$B595>="5/22/2011"+0),--('Transaction List'!$B46:$B595<="5/26/2011"+0),--('Transaction List'!$E46:$E595="Transportation")--('Transaction List'!$C46:$C595="Act1"),'Transaction List'!$G46:$G595)

However I haven't figured a way to pull the information that meets all the previous requirements as well as adding a rule that requires that the account be either Act1 OR Act2.

Any idea on how I could modify the function to have the additional rule that the information in Column C either equals Act1 OR Act2?

Thanks!

Travis

 

[Misca]

The safest/easiest way would be to have a SUMPRODUCT-function for both account names and SUM them together.

 

[Sandeep Warrier]

Try

=-1*SUMPRODUCT(--('Transaction List'!$B46:$B595>="5/22/2011"+0),--('Transaction List'!$B46:$B595<="5/26/2011"+0),--('Transaction List'!$E46:$E595="Transportation"),('Transaction List'!$C46:$C595="Act1")+('Transaction List'!$C46:$C595="Act2"),'Transaction List'!$G46:$G595)