I'm looking for a subtotal equation that I can use that sums a total column when filtered based on a criteria (sumif) for tbd. I'm currently using the following equation........=sumif($A:$A,"tbd*",B:B). The table below shows what I have when a filter is in place. Three names pop up when the filter is in place, however I need to find the total for tbd. What subtotal equation can I use to find the total for tbd when a filter is in place? The output should be tbd=1.
<tbody>
</tbody>
Name | Total |
John | 1 |
tbd | 1 |
Rick | 1 |
<tbody>
</tbody>