Quick CountIfsquery Please

Hello,

Hoping somebody can make my life easier please.

I'm currently using the following countifs formula:

=COUNTIFS({CoCode}, "114", {Status.}, "Not Started")

What can I change it to so I don't have to manually enter a new co. code(eg 114) and status (eg Not Started) every time? Imagine there is some way I can just tell the formula to include the text inside a certain cell and then drag it down/across etc.

This is what it looks like currently for reference.

Thank you

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would use somethign along the lines of:

=COUNTIFS({CoCode}, $[Column7]@row, {Status.}, [Column8]$15)

Just change the 15 after [Column8]$ to whatever row number has that text in it. Then you can dragfill down and to the right.

All comments

Kleerfyre

Highlight the quoted Not Started part. Then just click on the cell with Not Started in it. It should put the cell number into the formula. Now just move your cursor over the cell with the formula until you see the plus cursor and then hold down the mouse button and drag across.

Paul Newcome

You would use somethign along the lines of:

=COUNTIFS({CoCode}, $[Column7]@row, {Status.}, [Column8]$15)

Just change the 15 after [Column8]$ to whatever row number has that text in it. Then you can dragfill down and to the right.

David G11

Thanks so much all.

Paul Newcome

Happy to help. 👍️

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.