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