|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 28th, 2006, 11:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
March 28th, 2006, 11:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)
|
|
#3
March 28th, 2006, 11:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)
|
|
#4
March 28th, 2006, 11:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum IF
Try =SUMPRODUCT(A2:A100,B2:B100) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=527343
|
|
#5
March 29th, 2006, 12:27 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum IF
Got it to work...THANKS!
"daddylonglegs" wrote: Try =SUMPRODUCT(A2:A100,B2:B100) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=527343
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
