View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bec Bec is offline
external usenet poster
 
Posts: 15
Default 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