Hi,

The following formula results in "Value" and I can't understand why. I have a simple pivot table summarizing meals by department number. I need to sum meals based on a range of dept numbers.
# of meals in columns L and M of pivot table
Dept #'s in column K of pivot table

=SUMIFS(L5:M36,K5:K36,">="&O4,K5:K36,"<="&O5)