I figured it out with some Google searching.. had to take the 1 & 0 out of quotations!
On Sunday, October 11, 2015 at 5:45:46 PM UTC-5, Mark Butler wrote: > > Hello, > > I am trying to display the sum of a column of cell values which were > themselves generated by the following formula: > > =IF(Student01!E3=24, "1", "0") > > When I try to calculate the sum of these cells using > > =SUM(B1:B121) > > .. zero is displayed in my total box. > > Here is a link to the spreadsheet.. > > > https://docs.google.com/spreadsheets/d/1_jSuIUeo18qFvT86k_JEcRWOYZZpE47JPt2k1loIYHM/edit?usp=sharing > > > Thanks, > > Mark > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
