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