=countif

inon rettig

i am trying to count all cells that are greater then 0 but only on certain cells, not the whole column

as shown in print screen

i would also like to have a formula that shows cells in column that are greater than 0 but less than 100

what is the right formula?

thanks in advance

Find more posts tagged with

Accepted answers

All comments

BullandKhmer

Is it only parent rows that you dont want counted?

If so then you could add a helper column with a column formula

=count(decedents()),

then use a countifs formula

COUNTIFS([helper]:[helper],=0,[remain]:[remain],<>0)

Then for between 0 & 100

COUNTIFS([helper]:[helper],=0,[remain]:[remain],>0,[remain]:[remain],<100)

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.