Timeline for Issue trying to sum different columns
Current License: CC BY-SA 4.0
5 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Mar 31, 2020 at 21:35 | comment | added | marikamitsos | Glad I could help. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. | |
Mar 25, 2020 at 15:18 | comment | added | João Vaz | oh of course, that's exactly what I wanted. Thank you once again! | |
Mar 24, 2020 at 19:37 | comment | added | marikamitsos |
"my idea is to sum all values in one. Just in one cell and not in three different ones."??? Maybe I am missing something. So you want G2+H2+I2 ? If so, just wrap the formula with SUM . eg: =sum(QUERY(QUERY(A:D,"select sum(A), sum(B), sum(C) where month(D)+1=2 ",1), "select * OFFSET 1 ",0)) . If it is something else please update the sheet with cells with the expected results.
|
|
Mar 24, 2020 at 15:38 | comment | added | João Vaz | Hi marikamitsos, thank you so much for your reply! But my idea is to sum all values in one. Just in one cell and not in three different ones. Do you know how? | |
Mar 21, 2020 at 22:56 | history | answered | marikamitsos | CC BY-SA 4.0 |