| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple Sumproduct of 2 Columns, with some blank cells in range
ColA ColB
5 10 5 10 5 5 10 I'd like to sum the products of the two columns, while ignoring rows that have a blank cell, so in this case (5*10) + (5*10) + (5*10) ---it's skipping the third row. I'm not having luck adjusting a simple =sumproduct(ColA,ColB) formula. I did a search but didn't come up with anything that I understand how to adjust. Thanks for your help! SteveC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Sumproduct of 2 Columns, with some blank cells in range
aha, if you use an array formula ctrl shift enter it works... but is there
another way? "SteveC" wrote: ColA ColB 5 10 5 10 5 5 10 I'd like to sum the products of the two columns, while ignoring rows that have a blank cell, so in this case (5*10) + (5*10) + (5*10) ---it's skipping the third row. I'm not having luck adjusting a simple =sumproduct(ColA,ColB) formula. I did a search but didn't come up with anything that I understand how to adjust. Thanks for your help! SteveC |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Sumproduct of 2 Columns, with some blank cells in range
try this. Need NOT array enter
=SUMPRODUCT((C2:C50)*(D2:D50)*C2:D5) -- Don Guillett SalesAid Software "SteveC" wrote in message ... ColA ColB 5 10 5 10 5 5 10 I'd like to sum the products of the two columns, while ignoring rows that have a blank cell, so in this case (5*10) + (5*10) + (5*10) ---it's skipping the third row. I'm not having luck adjusting a simple =sumproduct(ColA,ColB) formula. I did a search but didn't come up with anything that I understand how to adjust. Thanks for your help! SteveC |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Sumproduct of 2 Columns, with some blank cells in range
=SUMPRODUCT(A1:A4,B1:B4)
will do it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "SteveC" wrote in message ... aha, if you use an array formula ctrl shift enter it works... but is there another way? "SteveC" wrote: ColA ColB 5 10 5 10 5 5 10 I'd like to sum the products of the two columns, while ignoring rows that have a blank cell, so in this case (5*10) + (5*10) + (5*10) ---it's skipping the third row. I'm not having luck adjusting a simple =sumproduct(ColA,ColB) formula. I did a search but didn't come up with anything that I understand how to adjust. Thanks for your help! SteveC |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Sumproduct of 2 Columns, with some blank cells in range
Don and Bob, thanks.
"Bob Phillips" wrote: =SUMPRODUCT(A1:A4,B1:B4) will do it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "SteveC" wrote in message ... aha, if you use an array formula ctrl shift enter it works... but is there another way? "SteveC" wrote: ColA ColB 5 10 5 10 5 5 10 I'd like to sum the products of the two columns, while ignoring rows that have a blank cell, so in this case (5*10) + (5*10) + (5*10) ---it's skipping the third row. I'm not having luck adjusting a simple =sumproduct(ColA,ColB) formula. I did a search but didn't come up with anything that I understand how to adjust. Thanks for your help! SteveC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| average price of 4 columns of figures but some cells can be blank | Excel Worksheet Functions | |||
| average price of 4 columns of figures but some cells can be blank | Excel Worksheet Functions | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Linear Mode
