Forum Discussion
Problematic SUMIF
Hello! My formula is not working and I have several rows to pick information from. Here is a sample row: 0101012 Cool Film Title 2011 306 Allied Health, Cool College Collecti...
Try
=SUMIF(E7:E120, "*Allied Health*", F7:F120)
But shouldn't it be
=SUMIF(F7:F120, "*Allied Health*", E7:E120)
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