Apr 17 2020 09:29 AM
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>
Apr 18 2020 01:16 AM
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>)