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