| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif for two ranges?
Example:
I'd like to use COUNTIF to alnalyze the following two ranges and come up with a formula that would spit out how many times joe is green. And then modify it for joe meeting a blue condition, mary meeting green, blue, etc. Is this possible? From what I've been reading COUNTIF can't compare two ranges? Is a macro the only way to go here? Any help would be appreciated. column A Column B joe green mary green joe blue joe blue joe green mary blue joe green mary green mary green |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
countif for two ranges?
=SUMPRODUCT(--(A1:A100="Joe"),--(B1:B100="green")
see http://www.xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message oups.com... Example: I'd like to use COUNTIF to alnalyze the following two ranges and come up with a formula that would spit out how many times joe is green. And then modify it for joe meeting a blue condition, mary meeting green, blue, etc. Is this possible? From what I've been reading COUNTIF can't compare two ranges? Is a macro the only way to go here? Any help would be appreciated. column A Column B joe green mary green joe blue joe blue joe green mary blue joe green mary green mary green |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
countif for two ranges?
absolutely perfect - you are a 1337 h4x0r
gracias |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
countif for two ranges?
Thanks - I hope being a "1337 h4x0r" is a good thing!
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message oups.com... absolutely perfect - you are a 1337 h4x0r gracias |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif & Ranges Question | Excel Discussion (Misc queries) | |||
| COUNTIF within date ranges | Charts and Charting in Excel | |||
| countif with non-continous ranges | Excel Worksheet Functions | |||
| Countif between ranges | Excel Discussion (Misc queries) | |||
| COUNTIF on one ranges with criteria from another | Excel Programming | |||
Linear Mode
