sumifs with subtotal

[bloodybrit90]

Hi,

I am having trouble combining the two statements below into one.

=SUMIFS(N$7:N$26,$D$7:$D$26,"LC Approved",$L$7:$L$26,$L30)

=SUBTOTAL(9,N$7:N$18)

I need to sum column N. Any help would be great.

Thanks.

 

[Andrew Poulsom]

You will need SUMPRODUCT. Start here:

http://www.mrexcel.com/forum/excel-questions/391084-sumproduct-subtotal-same-formula.html