Formula for summing X in a column

Copper Contributor

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>

1 Reply

@Bret33172 

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>)