[Solved] need help with IF conditions

[pluumy]

Hey, i'm pretty new to OpenOffice Calc.

I made a list to keep track of the anime series i've watched so far and i want to add a cell that counts how many shows i haven't finished yet. But if i use the COUNTIF method to check whether the cells in the E-column are empty, then it also counts all the empty cells farther down the list where i haven't input any shows as of yet. So i wanted to to check if the C-cell is not empty and if so check, if the corresponding E-cell is empty. How do i code this?

[FJCC]

One possibility is a formula like

Code: Select all

=SUMPRODUCT(ISTEXT(C6:C20);ISBLANK(E6:E20))

ISTEXT and ISBLANK return TRUE or FALSE and TRUE = 1 and FALSE = 0. SUMPRODUCT multiplies together the results in each row and then adds all of those products. If both the ISTEXT and the ISBLANK are TRUE, the product is 1, otherwise the product is zero. So the result of the sum action is to count how many rows result in TRUE for both conditions.

[pluumy]

Thank you very much. That worked perfectly!