Forum Discussion

AKing123's avatar
AKing123
Copper Contributor
Jun 12, 2026
Solved

CountIFS/SumIFS Question

Hello everyone, I'm working with a lot of data, and trying to find a way to add quantities already in the sheets but spread out over 500 or more rows. I'm not able to change how the data is delivere...
excel
Formulas and Functions
  • IlirU's avatar
    IlirU
    Jun 15, 2026

    AKing123​,

    Perhaps some of the numbers you have in column D (see screenshot I gave you in the previous post) are set as text. If so, then you can use the following formula.

    =LET(
     data, A2:D8,
      txt, DROP(data,, -1),
      num, --REGEXEXTRACT(TAKE(data,, -1), "\d+", 1),
     srch, SEARCH("Plain Bagel", txt),
           SUM(TOCOL(srch * BYROW(txt = "", OR) * num, 3),
               TOCOL(CHOOSECOLS(srch, 3) * num, 3))
)

    If you still have any possible problems, then I recommend that you post your file here in this forum (without sensitive data, email addresses, etc.). This way your problem can be seen / understood better and the contributors of this forum will give you the appropriate help.

    HTH

    IlirU

m_tarler's avatar
m_tarler
Silver Contributor
Jun 12, 2026

maybe try:

=SUMIFS(D1:D999, A1:A999, "Plain Bagel", B1:B999, "", C1:C999, "") + SUMIFS(D1:D999, C1:C999,"*Plain Bagel*")

AKing123's avatar
AKing123
Copper Contributor
Jun 13, 2026

Thank you for the assist! Oddly enough, when used on the example sheet like the one I posted here, it worked fine. But when I tried to use it on the actual sheet with all of the data and corrected columns, it kept coming back as "0." Would hidden or differently named columns make a difference?