Calculating todays register

Ed Gadd

Hi All,

I'm trying to create a formula which will count a one for a ticked box and count 0 for a crossed box.

I have a date column along side and wish to only count todays totals

Is there a formula which can do this please? Or should I simply populate the boxes with 1's and 0's?

Thank you

John_Foster

Hi @Ed Gadd,

What field type are you using? If it is a checked box these have values of 1 when ticked or 0 when not. If using this the formula would look like this.

=SUM(RowName:RowName)

If you are using symbols like the one below there is a word value for each symbol and the formula would look like this.

=COUNTIF(RowName:RowName,"Yes")

Hope this helps!

John

Ed Gadd

hi @John_Foster

Thanks for the quick reply. I'll take a look over this a little later.

Many thansk