I need to create a formula in excel that provides results only if 2 criteria are met in 2 different columns. I curently use the following formula: =COUNTIF(CMA_Report!C1:C296,"John Doe") . what formula can I use so that both criteria oreven 3 criteria, if met, will provide me with results (an item count on a table).
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.