OpenOffice Calc

From Torben's Wiki
Jump to: navigation, search

Open Office; OOo

Matching

A1:A10 =  ""
A1:A10 <> ""

CountIf with joined criteria of 2 columns

I want to join 2 CountIf like 

=CountIf(=COUNTIF(A1:A10,"j") 
=CountIf(=COUNTIF(B1:B10,"Dresden")
--> =SUMPRODUCT((A1:A10="j"),(A1:A10="Dresden"))
Retrieved from "http://www.entorb.net/wickie/OpenOffice_Calc"
Personal tools