The question sounds simple and I have seen several post similar to what I am trying to do, but what I have tried hasn't worked. Here is my example: I need to filter the list by the deceased person (col C). For example, I filter to only see Dennis. Then I need to subtotal the amount of money given to seeds and to peace tuition. Whatever I have tried has returned a total of $115 for seeds even if the list is filtered to not show the $15. I need to see only $100 for seeds. Then I assume I will have to write the formula again specific to peace tuition. To complicate more I need to have it on a different worksheet. Here are a couple of things I have tried .=IF(('GEN INFORMATION'!$D$5:D7),"seeds",SUBTOTAL(9,'GEN INFORMATION'!$E$5:E7)) also =SUMPRODUCT(--('GEN INFORMATION'!D5:D7="seeds"),'GEN INFORMATION'!E5:E7)
<colgroup><col><col><col></colgroup><tbody>
</tbody>
NAME OF | FUND DONATION | AMT. OF |
DECEASED | GIVEN TO | DONATION |
Dawn Hoeg | Seeds | $15.00 |
Dennis Ernest | Seeds | $100.00 |
Dennis Ernest | Peace tuition | $50.00 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>