SUMIFS including hidden rows

[moosie]

Hello,

I am using the SUMIFS function but I have alot of rows hidden because
otherwise it will become a very long list of data and I only need to see the
latest added numbers but I do need to see the total sum of the SUMIFS
function but I seems it will only give me the unhidden cels.

Can anybody tell me how to include the hidden cels ?

Thanks in advance

Jeroen

 

[Bob Phillips]

SUMIF DOES include hidden rows, manually hidden and/or hidden by a filter,
so I cannot see your problem here.