title: Counting TRUE for Values obtained from if function
body: <p>I have applied if formula to display TRUE or False when condition is TRUE and false respectively. However, the count formula is unable to count the number of Trues obtained from the aforementioned formula even when I reference the cell with the value TRUE or use direct reference as &quot;TRUE&quot; in the formula. Can anyone tell me why this is happening and how to reference the value of TRUE to countif?</p>