Count Formula Help

Question

Hello,&nbsp;I am trying to count the number of days an employee had a hotel charge. I am trying to use the formula to only count the day labeled fields over 0.00 Here is my Table: (as you can see the count is over 7 and doesn't seem to be impacted by &gt;0)

Here is my Formula:&nbsp;

Can you help?
------------------------------Thanks, Tara------------------------------

markshnier__you · Answer

Can you you copy and paste you formula do we can read it better.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

tarastroup · Answer

Count([Sunday],[Monday],[Tuesday],[Wednesday],[Thursday],[Friday],[Saturday]&gt;0,0,1)Thanks!------------------------------Tara Stroup------------------------------

markshnier__you · Answer

try thisCount([Sunday]&gt;0,[Monday]&gt;0,[Tuesday]&gt;0,[Wednesday]&gt;0,[Thursday]&gt;0,[Friday]&gt;0,[Saturday]&gt;0)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

tarastroup · Answer

Yahooo! Thank you Mark!------------------------------Tara Stroup------------------------------

Forum Discussion

Count Formula Help

Related Content

Delete Formula Button Error

Formula Assistance

Count Formula with Conditions

Formula Url Buttons

Formula Query with custom key