Timeline for Run formula that checks multiple cells and outputs to one cell
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 23, 2020 at 3:20 | vote | accept | Alex | ||
| Jan 23, 2020 at 3:19 | comment | added | Alex | Thankyou, that's exactly what I needed | |
| Jan 22, 2020 at 22:33 | comment | added | marikamitsos | I had completely misread your question. The formula is now fixed. | |
| Jan 22, 2020 at 22:30 | history | edited | marikamitsos | CC BY-SA 4.0 |
Fixed formula
|
| Jan 21, 2020 at 21:07 | comment | added | Alex | I've applied this formula to the spreadsheet, but it's producing wildly incorrect results. screenshot The green highlighted numbers are the ones that match the cell in column B, red do not. The formula is applied to the bottom of each column EXCEPT for column B (which has its own =SUM). The expected outcome is that the bottom cell would be the sum of the green numbers, while ignoring red numbers | |
| Jan 21, 2020 at 18:01 | history | answered | marikamitsos | CC BY-SA 4.0 |
