Cross sheet formula

Hi Brain trust

I am needing to return a count

I need to return how many Notices do i have reporting "Data" in the Data column for the FY Quater - My formula is off and i cant figure it out

=COUNTIFS({Types1}, [Primary Column]@row , {Data}, "DATA", {FY QTR}, [Column3]35)

Find more posts tagged with

Accepted answers

Paul Newcome

Are you able to provide screenshots fo the source data as well as all columns referenced in your formula?

Have you tried breaking it down into three separate COUNTIFS (one for each range/criteria set) to try to pinnpoint which one is throwing things off?

Susan van Niekerk

Hi Paul

It was that last range/criteria that was throwing it off, have managed to fix it and working now

All comments

Paul Newcome

Are you able to provide screenshots fo the source data as well as all columns referenced in your formula?

Have you tried breaking it down into three separate COUNTIFS (one for each range/criteria set) to try to pinnpoint which one is throwing things off?

Susan van Niekerk

Hi Paul

It was that last range/criteria that was throwing it off, have managed to fix it and working now

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.