Forum Discussion
Formula for summing X in a column
I have a spreadsheet that I have marked columns with an X to show I have received a document. What formula can I use to add up all the cells marked with an X in that particular column>
If you want the number of cells with "x", use this:
=COUNTIF(<range>,"x")If you want to sum values from one column where there is an "x" in another, use this:
=SUMIF(<range>,"x",<sum range>)