I have a SUMIF-formula which I need some help with. The formula is SUMIF(T7:T128);"=1") but I would like to add a statement that if a cell in column T (for example T99) and that cell has an "1" in it but is preceded by a cell, on the same row, with an "1" in it in the previous column (in this case cell S99 the "1" in cell T99 should not be counted. How do I write that formula (hope my questions makes sense).
Kind regards,
Hans
Bookmarks