How to make a COUNTIF or an averageif when I need to check the values in two columns... for example, if the column has = "ABC" and column B > 0

Office

Question:How to make a COUNTIF or an averageif when I need to check the values in two columns... for example, "If a ="ABC"column and column b > 0" then count or average column b.I know I can do "= countif (B6..)"B50, "> 0") "..."But how to include the additional requirement of "A6"...A50, "= ABC WORK?";)Answer:HelloTo count= COUNTIFS(A6:A50,"ABC",B6:B50,">0")According to the average= AVERAGEIFS...Read More

Posted: 26 Jan 2012

Tags: How to make a COUNTIF or an averageif when I need to check the values in two columns for example if the column has ABC and column B gt 0 How make COUNTIF averageif when need check the values two columns for example column has ABC and