CountIF

system · January 6, 2006, 3:26pm

Hello,

I hope there is a solution for my Problem.
I want to count all Values that are grater than 0 and not empty.

I tried this but they din’t work.

=Sum(If (IsNumber()) Then 1 Else 0) → #IERR

= Where > 0 → Syntax Error (DMB0007)

Why does this work but if I want to check a Number not???
= Where (=“Solved/Completed on first call”)

Thanks for any help

Daniel

dhartung (BOB member since 2004-11-08)

system · January 6, 2006, 3:52pm

Moving to BusObj Classic forum. If this is not the correct product forum, let us know and it will be moved accordingly.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · January 6, 2006, 6:37pm

Try this:

=Sum(If Not IsNull() Then If > 0 Then 1 Else 0)

Mahi (BOB member since 2004-07-22)

system · January 6, 2006, 9:58pm

Regarding

Andreas (BOB member since 2002-06-20)