Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easier way?
There has got to be an easier to accomplish the same end results as the attached formula... any pointers? +-------------------------------------------------------------------+ |Filename: Doc2.doc | |Download: http://www.excelforum.com/attachment.php?postid=4133 | +-------------------------------------------------------------------+ -- wmaughan ------------------------------------------------------------------------ wmaughan's Profile: http://www.excelforum.com/member.php...o&userid=29743 View this thread: http://www.excelforum.com/showthread...hreadid=494743 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easier way?
Hi, try this array formula: =SUM((B12:E12)*(B17:E17)) entered with SHIFT+CTRL+ENTER HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=494743 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easier way?
So simple, thanks, it worked! -- wmaughan ------------------------------------------------------------------------ wmaughan's Profile: http://www.excelforum.com/member.php...o&userid=29743 View this thread: http://www.excelforum.com/showthread...hreadid=494743 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easier way?
Or use sumproduct as MS originally intended <bg
=SUMPRODUCT(B12:E12,B17:E17) -- Regards, Peo Sjoblom (No private emails please) "Sandy Mann" wrote in message ... with @tiscali.co.uk "pinmaster" wrote in message ... Hi, try this array formula: =SUM((B12:E12)*(B17:E17)) entered with SHIFT+CTRL+ENTER HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=494743 Or without having to array enter: =SUMPRODUCT(B12:E12*B17:E17) -- HTH Sandy |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easier way?
"Peo Sjoblom" wrote in message
... Or use sumproduct as MS originally intended <bg =SUMPRODUCT(B12:E12,B17:E17) Back to basics - now there's a real revelation! <vbg -- Regards Sandy with @tiscali.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Splitting easier? (Tokeniser?) | Excel Worksheet Functions | |||
Easier Way? | Excel Worksheet Functions | |||
Please make it easier to access the IS functions (e.g., isblank) . | Excel Worksheet Functions | |||
Trying to enlarge tab size on worksheet for easier reading | Excel Discussion (Misc queries) | |||
Excel Hyperlink: Is there an easier way to follow then double-cli. | Excel Discussion (Misc queries) |