MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

CountIF Function

  Asked By: Nisha    Date: Jan 06    Category: MS Office    Views: 764

I know this isn't strictly a VBA question but it is used in my spreadsheet that
you've helped on before.

I have a countif function counting for particular letters and times by the cell
value above it but occasionally the cells lose the references.

I want to count multiple letters and this is the way I have found works but is
there a better way?

Note the + inbetween each countif statement.




3 Answers Found

Answer #1    Answered By: Burke Martin     Answered On: Jan 06

I think you need to give more info.

Why are you using a COUNTIF to search just the single cell B7? This would
better be done with a simple IF statement. I.e. your statement  can be
replaced with


But what do you mean by "... occasionally the cells  lose the references"?

Answer #2    Answered By: Rolando Reed     Answered On: Jan 06

You are a star as always.

That work perfectly. I think because I've adapted my spreadsheet  to work in
another way I didn't consider changing the way it counted the cells.

And by losing the references  i meant that the countif's would lose the reference
to which cell they were looking at and i an only presume it was my rubbish
statement that was doing it.

Once again thank you for your time.

Answer #3    Answered By: Luete Fischer     Answered On: Jan 06

See if this one gives you what you need:

Didn't find what you were looking for? Find more on CountIF Function Or get search suggestion and latest updates.