Use SUMIFS on pivot table data

[malta1]

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)

[Admin]

Hi

Welcome to board.

Use either of this

=SUMPRODUCT(--(K5:K36>=O4),--(K5:K36<=O5),L5:L36+M5:M36)

=SUM(IF(K5:K36>=O4,IF(K5:K15<=O5,L5:M36)))

The second one is an array formula.