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