Running total for 2 columns IF column 3.......
 

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

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

Running total for 2 columns IF column 3.......
 

Try the below

=SUMPRODUCT((G1:G10="letter")*C1:C10*E1:E10)

=SUMPRODUCT((G1:G10="tabloid")*C1:C10*E1:E10*2)

If this post helps click Yes
---------------
Jacob Skaria


"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

Running total for 2 columns IF column 3.......
 

What happens if G does not equal either of those choices? In this formula, it
causes the result to be 0.

=C2*E2*IF(G2="letter",1,IF(G2="tabloid",2,0)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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

Running total for 2 columns IF column 3.......
 

Hi,
try

=IF(SUMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4))0,S UMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4)),IF(SUMPR ODUCT((A1:A4="tabloid")*(B1:B4*E1:E4*2))0,SUMPROD UCT((A1:A4="tabloid")*(B1:B4*E1:E4*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

Running total for 2 columns IF column 3.......
 

hI,
This formula will work better specially if you have both words in the column

=SUMPRODUCT((A1:A5="tabloid")*(B1:B5*E1:E5*2))+SUM PRODUCT((A1:A5="letter")*(B1:B5*E1:E5))

"Eduardo" wrote:

Hi,
try

=IF(SUMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4))0,S UMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4)),IF(SUMPR ODUCT((A1:A4="tabloid")*(B1:B4*E1:E4*2))0,SUMPROD UCT((A1:A4="tabloid")*(B1:B4*E1:E4*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

Running total for 2 columns IF column 3.......
 

Perfect!!
Thank you

"Eduardo" wrote:

hI,
This formula will work better specially if you have both words in the column

=SUMPRODUCT((A1:A5="tabloid")*(B1:B5*E1:E5*2))+SUM PRODUCT((A1:A5="letter")*(B1:B5*E1:E5))

"Eduardo" wrote:

Hi,
try

=IF(SUMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4))0,S UMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4)),IF(SUMPR ODUCT((A1:A4="tabloid")*(B1:B4*E1:E4*2))0,SUMPROD UCT((A1:A4="tabloid")*(B1:B4*E1:E4*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

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