Forum Discussion
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"))
How about
=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")
3 Replies
=SUMPRODUCT((D2:D2954="Done")*(B2:B2954=F1))
Dynamically enter serach value for column B in cell F1 with above formula.
How about
=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")
- Thanks that work great!, Appreciate the help!
