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.
