Sum IF
 

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

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)

Sum IF
 

Gavin,

This works for the '2' row, but how do I apply this formula to Sum the
column (i.e. a range of cells in the column (rows 2 through 100, for example)?

Thanks , in advance!

"Gavin" wrote:


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)