Sep 23 2022 06:45 AM
I have a spreadsheet. I need a formula to add 2 cells together, one of the cells will be a different cell depending if there is a value in another cell I have tried sumifs with the value for the 3rd cell as either <0 or >0 but can't get it to work also tried countifs
My answer needs to be sum of A+D if B is less than zero or sum of C+D if B is more than zero
Sep 23 2022 06:51 AM
Sep 23 2022 07:11 AM
Sep 23 2022 07:21 AM
What do you want to return if B1 is blank? And if B1 contains 0?
Sep 23 2022 07:26 AM