Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct formula
I am trying to get a formula that
1. if a cell in column c is greater than zero will multiply that cell by another and total the result by column. What I have is (which is not working) =SUMPRODUCT(--($C$7:$C$640),$C$7:$C$64*D$7:D$64) Column C Column D 5 100 0 400 2 300 4 200 = 500+600+800 Thanks, Todd |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct formula
Hi Todd Your formula should work if you just have numbers or blanks in C7:D64, what result do you get? Why doesn't it work? This slight modification might help =SUMPRODUCT(--($C$7:$C$640),$C$7:$C$64,D$7:D$64) although if you never have negative values in column C you could just use =SUMPRODUCT($C$7:$C$64,D$7:D$64) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=520863 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct formula
I was wrong! it wasn't that formula but the formula being used to check it
with. Thank you for the help. "daddylonglegs" wrote: Hi Todd Your formula should work if you just have numbers or blanks in C7:D64, what result do you get? Why doesn't it work? This slight modification might help =SUMPRODUCT(--($C$7:$C$640),$C$7:$C$64,D$7:D$64) although if you never have negative values in column C you could just use =SUMPRODUCT($C$7:$C$64,D$7:D$64) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=520863 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Modify A SumProduct Formula | Excel Worksheet Functions | |||
sumproduct formula to slow | Excel Worksheet Functions | |||
SUMPRODUCT formula | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |