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...">
Stumbleupon Facebook Twitter Digg Google Delicious Linkedin
TechNews
TechNews Office 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

Search Something

News Categories

Latest Buzz

Related Buzz

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

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

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:

Hello

To count

= COUNTIFS(A6:A50,"ABC",B6:B50,">0")

According to the average

= AVERAGEIFS(B6:B50,A6:A50,"ABC",B6:B50,">0")

Rate this article:

  • Pages:
  • 1

0 Comments

Add Your Comment !


Home Add Your Article Categories

2012 - TechNews