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")
=SUMPRODUCT((D2:D2954="Done")*(B2:B2954=F1))
Dynamically enter serach value for column B in cell F1 with above formula.