| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summing "False" and "True"
I have an equality -
Cell A1 "=B1C1" The value is true since cell B1=10 and C1=3 This repeats down to row 100. A2, A3, ...A100 I want to sum up the number of True statements. I use Sumproduct((A1:A100=1)*1), But this equals zero. Why doesn't this add 1 when the value is true. Isn't the value of cell A1 = 1 since the result is a true statement. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
| Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
| if logical test true, then hlookup, if false then difference betwe | Excel Worksheet Functions | |||
| Adding True False Results | Excel Worksheet Functions | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
Threaded Mode
