COUNTA not doing what it's supposed to be doing

**kyber** · 08-24-2021, 02:45 PM

I'm trying to get a tally of how many visitors the individual has seen. For some reason COUNTA is not summing that up. The reason why I'm using COUNTA is because in the even there are duplicate visitors it still needs to count them.

**JohnTopley** · 08-24-2021, 02:59 PM

Try

=IF(A16="","",COUNTIF(Table1[Individual],A16))

**kyber** · 08-24-2021, 03:02 PM

I think that's a good workaround. Thank you!

COUNTA not doing what it's supposed to be doing

LinkBack

Thread Tools

Rate This Thread

Display

COUNTA not doing what it's supposed to be doing

Re: COUNTA not doing what it's supposed to be doing

Re: COUNTA not doing what it's supposed to be doing

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] IF formula not doing what it's supposed to

[SOLVED] code does what its supposed to but errors out at the end. Dont know why

Help required please - Sheet not doing what it's supposed to

Data flies everywhere else but where it's supposed to go...

Cell Populated When It's Supposed To Have Nothing In It

Read Only-why it doesn't do what it is supposed to

Look up not working as the way it is supposed to

Bookmarks

Bookmarks

Posting Permissions