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

--
__________________________________
HTH

Bob

"moosie" wrote in message
...
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