Sum IF
Brent wrote:
I have 2 columns (Column A = "Per Game Fee" , Column B = "Number of Games").
I am attempting to total Column A after it has been multiplied by Column B.
column B may have the occassional '0'(Zero), and therefore shouldn't be added
to the cummulative total of 'A'.
Thanks,
Brent
=if(B20,A2*B2,0)
|