COUNT but not if duplicated in another row

Looking for some help with a formula... really not sure where to start. I have a sheet where each line relates to scaffold that has been built which is populated by a webform. Each line has a tag number and if I count all the tags in the column Tag No, I can see how many scaffolds are in place. The webform also collects if a scaffold comes down and that same Tag No is entered into the 'Tag No Dismantled' column. What I'm looking for is a formula that counts how many scaffold are up, but not to count them if a tag number is mentioned in the 'Tag No Dismantled' column.

Hopefully this makes sense?

Find more posts tagged with

Accepted answers

Antonio Figueroa

You could use

=count([Tag No]:[Tag No])-count([Tag No D]:[Tag No D])

All comments

Antonio Figueroa

Can you share a Snip of your sheet.

Jo Petch

Here is a snip of the columns. Many thanks, Jo

Antonio Figueroa

You could use

=count([Tag No]:[Tag No])-count([Tag No D]:[Tag No D])

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.