Excel

Copper Contributor

How do you add up only the Xs place in a column

1 Reply

@Danielle1665 

 

COUNTIF function

In its simplest form, COUNTIF says:

  • =COUNTIF(Where do you want to look?, What do you want to look for?)

For example:

  • =COUNTIF(A2:A5,"X")

  • =COUNTIF(A2:A5,A4)

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.