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)