Sumproduct igoring hidden value
With data from row1 to row10 try the below...sum col C based on two
conditions in A and B
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C1:C10,ROW(C1:C10)-MIN(
ROW(C1:C10)),0,1)),--(A1:A10="a")*(B1:B10="b"),C1:C10)
If this post helps click Yes
---------------
Jacob Skaria
"Edward Wang" wrote:
Hi,
How can I use sumproduct function and igore hidden value. The function usage
likes below:
=sumproduct((range1=criteria1)*(rang2=criterial2)* rang4), and I am using
filter on range3.
I expect the function result can igore the any hidden value I made on range 3.
P.S. each range is one column with same row number.
Thanks,
|