Forum Discussion

QWeelon's avatar
QWeelon
Brass Contributor
Apr 24, 2021
Solved

Sumproduct with a wildcard condition

Dear community,   I'm struggling with a formula where I want to use a wildcard condition to sum and multiply values if the corresponding month is mentioned. In other words, for January, I want to w...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Apr 24, 2021

    QWeelon 

    Without a helper column:

     

    =SUMPRODUCT(--ISNUMBER(FIND("Jan",N18:N22)),K18:K22,L18:L22)

     

    Corrected typo

HansVogelaar's avatar
HansVogelaar
MVP
Apr 24, 2021

QWeelon 

Without a helper column:

 

=SUMPRODUCT(--ISNUMBER(FIND("Jan",N18:N22)),K18:K22,L18:L22)

 

Corrected typo

  • QWeelon's avatar
    QWeelon
    Brass Contributor
    Apr 24, 2021
    HansVogelaar,

    Did some error searching and it worked like a charm when I removed the comma before "Jan". Thank you!

    SergeiBaklan,
    Neat, that's one clean formula. I'm amazed by how simple some things are with the right knowledge and formulas. Very nice indeed!

    =SUMPRODUCT(--ISNUMBER(FIND("Jan",N18:N22)),K18:K22,L18:L22)

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Apr 24, 2021

      QWeelon 

      I have corrected my previous reply. Thanks for pointing out the mistake!

  • QWeelon's avatar
    QWeelon
    Brass Contributor
    Apr 24, 2021
    Hi,

    Thank you for answer!

    I figured there ought to be a way, although the formula don't seem to work for me. I still get a 0 in output. I'm using 365..

    Regards

Resources