Sum IF

B

Brent

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
 
G

Gavin

Brent said:
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
Click to expand...

=if(B2>0,A2*B2,0)
 
B

Brent

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!
 
Top