Forum Discussion
Solved
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 dat...
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")
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!