| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sumproduct only filtered data
Hi,
I have two tables a2:a100 and b2:b100. I am using the formular =SUMPRODUKT(A2:A100;B2:B100) to arrive at a total sum, after each row is first multiplied (a2*b2 ...a100*b100). This appears to work fine. However, once I filter the data, the SUMPRODUCT continues to include all rows rather than just those appearing after the filtering. I have read through a lot of the Q&A's on this page, but still can't get it to work. Thus, I would be grateful for your help. Thanks, Niclas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
| Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
| Sumproduct on filtered cells | Excel Worksheet Functions | |||
Threaded Mode
