Sumproduct Subtotal
I have the following formula and would like to use a subtotal, can anyone help?
=SUMPRODUCT((O21:O10060)*(N21:N1006=0)*($C21:$C10 06))
Essentially the formula is counting addition of vehicles in the current
month. i.e. Counts if the col O0 and col N equals 0
|