Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula?
Hi, This one has me stumped. This formula is non-functional but it may help explain what I want to do. I need to Multiply rows of cells 6:11 by 60 if both cells in the B Column are not blank and adjacent cells C6:C11 read "Local". =SUMPRODUCT(--(=COUNTA(B6:B11)),--(E6:E11="Local"))*60 Thanks to anyone who can help. Dan -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=521167 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula?
Hi!
Try this: =SUMPRODUCT(--(B6:B11<""),--(E6:E11="Local"))*60 Biff "dansargeant" wrote in message ... Hi, This one has me stumped. This formula is non-functional but it may help explain what I want to do. I need to Multiply rows of cells 6:11 by 60 if both cells in the B Column are not blank and adjacent cells C6:C11 read "Local". =SUMPRODUCT(--(=COUNTA(B6:B11)),--(E6:E11="Local"))*60 Thanks to anyone who can help. Dan -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=521167 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula?
This seems to work:
=SUMPRODUCT(--(B6:B11 < ""),--(E6:E11="Local"),(B6:B11 * 60)) Note: I used your example formula for e6:e11 rather than your description which said c6:c11. "dansargeant" wrote: Hi, This one has me stumped. This formula is non-functional but it may help explain what I want to do. I need to Multiply rows of cells 6:11 by 60 if both cells in the B Column are not blank and adjacent cells C6:C11 read "Local". =SUMPRODUCT(--(=COUNTA(B6:B11)),--(E6:E11="Local"))*60 Thanks to anyone who can help. Dan -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=521167 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula?
Thanks Biff, You did it again. Works great! DS -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=521167 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula?
You're welcome!
Biff "dansargeant" wrote in message ... Thanks Biff, You did it again. Works great! DS -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=521167 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |