Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF on one ranges with criteria from another
Hello,
I want to perform a countif on a given range e.g.: COUNTIF (G12:G29,"A") after checking for a different criteria in a different range; say A12:A29 equals GroupX. In otherwords, how do I only count the C's in Range One when th Range Two equals GroupX. The data is all text. Thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif for multiple ranges and criteria | Excel Discussion (Misc queries) | |||
COUNTIF with multiple disjoint ranges, same criteria | New Users to Excel | |||
COUNTIF with multiple disjoint ranges, same criteria | New Users to Excel | |||
COUNTIF with multiple disjoint ranges, same criteria | New Users to Excel | |||
COUNTIF criteria using date ranges? | Excel Worksheet Functions |