I'm looking for a solution to a simple problem. I want to sum several non-contiguous cells in a column. Some of the cells, however, have text (usually some text like "SKIP") instead of a number. I have tried using SUMIF like:
=SUMIF((A4,A8,A12,A16),"<>'SKIP'")
This gives error in the cell...