Calcs for a multiple conditions

Hi,

I want to use this formula:

=COUNTIFS({1. Main Tracker Range 1}, "Pending", {1. Main Tracker Range 3}, TODAY(-1)) + COUNTIFS({1. Main Tracker Range 1}, "Confirmed", {1. Main Tracker Range 3}, TODAY(-1))

Which has two different conditions, this worked in the Summary tab. When I am referencing it is not coming out.

In general, is there a way to refer a Summary Tab in another sheet or calculate the multiple conditions. I want to know what is the flaw here?

Thank you!

Find more posts tagged with

Sheets

Automations

Sheet Summary

Accepted answers

All comments

Paul Newcome

Are you able to provide more details? What do you mean by "referencing it"? What do you mean by "it is not coming out"? What exactly are you trying to do?

Galizada

Hi,

Referencing, I have a cross sheet and in the same sheet two different columns. I mean to refer to another sheet.

+In one columns I want to select two variables "Pending" and "Confirmed" statuses which has "TODAY" and see their total. It worked when I am calculating in the source sheet but reference is not working.

Galizada

Figured out:

Calculations should be like this:

=COUNTIFS({1. Main Tracker Range 1}, "Pending", {1. Main Tracker Range 8}, TODAY(), {1. Main Tracker Range 1}, "Confirmed", {1. Main Tracker Range 8}, TODAY())

No need any "+" or additional sign, right order of the conditions will solve the issue.

Paul Newcome

Have you confirmed that formula is actually working by outputting the correct count?

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.