Excel sum if cell is positive;
Solved
buteorufinus
-
buteorufinus -
buteorufinus -
Hello,
in a time management spreadsheet, I want to sum the cells in a column.
In the cells, the formula results (=TEXT(E8-F1; "h:mm")) are expressed in the h:mm format.
Some are positive, others are negative; I want to sum the cells at the bottom of this column,
but only if the result in the cell is positive. The addition should therefore ignore the cells whose result is negative (if <0 count 0).
Since the spreadsheet manages working hours, the result in each cell varies according to the months.
Can you help me write my formula?
Column F, from cell F3 to F33.
Thank you for your help.
in a time management spreadsheet, I want to sum the cells in a column.
In the cells, the formula results (=TEXT(E8-F1; "h:mm")) are expressed in the h:mm format.
Some are positive, others are negative; I want to sum the cells at the bottom of this column,
but only if the result in the cell is positive. The addition should therefore ignore the cells whose result is negative (if <0 count 0).
Since the spreadsheet manages working hours, the result in each cell varies according to the months.
Can you help me write my formula?
Column F, from cell F3 to F33.
Thank you for your help.
Configuration: Windows XP Internet Explorer 7.0
7 réponses
Hello,
I didn't quite understand your hours column in text format. If it’s not column F and the data in F is numerical, the formula is
=SUMIF(F3:F33, ">0")
Otherwise, please provide a file without confidential data in your discussion with this link so we can understand your request
https://www.cjoint.com/
--
Talk to you later
Mike-31
If there is no solution, there is no problem.
I didn't quite understand your hours column in text format. If it’s not column F and the data in F is numerical, the formula is
=SUMIF(F3:F33, ">0")
Otherwise, please provide a file without confidential data in your discussion with this link so we can understand your request
https://www.cjoint.com/
--
Talk to you later
Mike-31
If there is no solution, there is no problem.
