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