Thread: Running total for 2 columns IF column 3.......
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Running total for 2 columns IF column 3.......
=SUMPRODUCT((G1:G100={"letter","tabloid"})*(C1:C10 0*E1:E100)*{1,2})


"paulab" wrote:


Can anyone help, I am trying to keep a running total of impressions based on
daily entries throughout the month:
If column G = "letter" than column C (sets) * column E (pages)
If column G = "tabloid" than column C (sets) * column E (pages)*2

Thank you in advance,
paulab
Reply With QuoteReply With Quote