SOLVED

New Contributor

# Excel Formula for Filtering 2 Columns and Counting the filter cells

I am looking to create a formula that will filter/count 2 Separate columns in the same bulk data, and the counts the cell that only have the data I'm looking to quantify.

I have 3000 Rows of data, Column B has "Email, Call, Reminder, Assigned Task"; Column D has "Done, To Do". I want a formula that provides me a count of Column B, that matches Done in Column D

Thoughts? Help?

I've Tried, not successful

=COUNTA('ACT PTD YTD'!D:D="Done", 'ACT PTD YTD'!B:B="Call")

=COUNTA('ACT PTD YTD'!A2:F3000(Filter 'ACT PTD YTD'! D:D,"To Do", Filter 'ACT PTD YTD'! B:B,"Call"))

3 Replies
best response confirmed by NathanDellinger (New Contributor)
Solution

# Re: Excel Formula for Filtering 2 Columns and Counting the filter cells

=COUNTIFS('ACT PTD YTD'!D:D, "Done", 'ACT PTD YTD'!B:B, "Call")

=COUNTIFS('ACT PTD YTD'!D:D, "To do", 'ACT PTD YTD'!B:B, "Call")

# Re: Excel Formula for Filtering 2 Columns and Counting the filter cells

=SUMPRODUCT((D2:D2954="Done")*(B2:B2954=F1))

Dynamically enter serach value for column B in cell F1 with above formula.

# Re: Excel Formula for Filtering 2 Columns and Counting the filter cells

Thanks that work great!, Appreciate the help!