SOLVED

Excel Formula - Filter 2 Rows of Data and then Subtotal a 3rd column.

New Contributor

I am looking to create a formula that will filter 2 Separate columns in the same bulk data, and the totals the amount left in the 3rd column. 

 

I have 3000 Rows of data, Column B has "Dollar Amounts”; Column D has "Names”, Column E has the “Lost, Won, Open”

 

Thoughts? Help?

I've Tried, not successful

 

=SUMIF('Individual YTD'!D:D, "Name", 'Individual YTD'!E:E, :Lost",'Individual YTD'!B:B)

 

=Subtotal,9('Individual YTD'!D:D, "Name", 'Individual YTD'!E:E, :Lost",'Individual YTD'!B:B)

1 Reply
best response confirmed by NathanDellinger (New Contributor)
Solution

@NathanDellinger 

Try

 

=SUMIFS('Individual YTD'!B:B, 'Individual YTD'!D:D, "Name", 'Individual YTD'!E:E, "Lost")

 

  • SUMIFS instead of SUMIF.
  • Arguments in different order.
  • "Lost" instead of :Lost"