Why is it that when I drag a formula the information I am looking for is not preserved?

Esta es mi función:

=COUNTIFS({LAYOUT CHECK FOR DAL Rango 2}, $Date$1, {LAYOUT CHECK FOR DAL Range 5}, "DAL 2", {LAYOUT CHECK FOR DAL Range 6}, "No")

Si la arrastro en otros ´10 ítems hacia abajo, se pierde la secuencia lógica, lo subrayado en gris es la columna "Rango" que no respeta

Cuando actualizo referencia hace como un loop y se actualiza toda la hoja como volviéndose loca

Find more posts tagged with

Formulas

Accepted answers

All comments

Ana Laura Rojas Nunez

Cunado arrastro la formula hacia abajo en los siguientes ítems a evaluar no respeta el rango en color gris y no jala la info de la hoja, a que se debe ?

Paul Newcome

In the formula in your post you have $Date$1, but the formula in your screenshot has Date1. The formula in your screenshot does not have the cell reference "locked in".

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.