Thread: Running total for 2 columns IF column 3.......
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Running total for 2 columns IF column 3.......
=IF(G1="letter",C1*E1,IF(G1="tabloid",C1*E1*2))


On 9 Lis, 14:26, 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