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
|