Forum Discussion
Blank cell as criteria for SUMIFS
I have 3 columns I need to look at to add certain numbers in my 4th column, and the third criterion column must be blank in order to add the number in the 4th cell. Here is the formula I've been tryi...
=SUMIFS(UnitValue,Modelos,$H68,CorM,$U68,PeriodStart,$W68,AllocationMethod,"="&$V68)
V68 is blank. It does not work with just the reference to the blank cell. In other situations, "=" will work.
You just have to add the "=" to make it work? Not sure why?