Forum Discussion

daemonlibrarian's avatar
daemonlibrarian
Copper Contributor
Apr 16, 2025

Problematic SUMIF

Hello!

My formula is not working and I have several rows to pick information from. Here is a sample row:

 

0101012Cool Film Title2011306Allied Health, Cool College Collection, FMG Business & Economics, FMG Humanities & Social Sciences Collection
 

I am trying to write a formula much like COUNTIF but SUMIF. The F column cells can have any mixture of collections, so some may have one collection listed, and some will have multiple collections listed. I tried variations of:

=SUMIF(E7:E120, "Allied Health", F7:F120)

but with no luck. 

Any help is greatly appreciated!

Missy

Excel
Excel for web
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 16, 2025

    Try

    =SUMIF(E7:E120, "*Allied Health*", F7:F120)

    But shouldn't it be

    =SUMIF(F7:F120, "*Allied Health*", E7:E120)

    • daemonlibrarian's avatar
      daemonlibrarian
      Copper Contributor
      Apr 16, 2025

      Thanks Hans! That was part of the problem. The other is that when I saved the table, that column saved as Number Stored as Text for some reason. Once I saw that and changed it, the new formula worked. 

      Mis

Resources