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 |
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) |