Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif: Multiple Columns
Hi folks,
I have two ranges and am trying to count how many times "0" occurs simultaneously in both. Example: A B C X 0 0 Y 3 1 Z 5 0 XX 0 0 The countif should come back as "2" (2 values [x and xx] share 0 in common) I tried =Countif(B2:B100, "0") + Countif(C2:C100, "0"). That didn't work even though one would think "+" should be an "and" and not an "or" (Excel treated "+" as an "or" so that in the above example the result came back as "3") I've read in other help sites a pivot table would be the best tool to use, but I really didn't want to get that complicated...it's a pretty simple spredsheet. Thanks for any help, R.E. Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
Countif Using Multiple Columns | Excel Worksheet Functions | |||
Sum or Countif over Multiple Columns | Excel Worksheet Functions | |||
using a countif with multiple columns | Excel Worksheet Functions | |||
Using Countif on multiple columns | Excel Worksheet Functions |