Forum Discussion
SUMIF Formula
Why is this formula working for the first set of cells but not the other? See attached.
Because C8 contains "ZM " (with a space at the end) instead of "ZM".
You can remove the space, or change the formula to
=SUMIF(C8,"ZM*",D8)
The latter will work whether there is a space at the end or not.