Forum Discussion
Solved
Excel Formula - Filter 2 Rows of Data and then Subtotal a 3rd column.
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 Amoun...
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"
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"