| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct - visible cells
Hi,
I trying to to use sumproduct only on visible cells and having a hard time. I read through many help sites, but can't seem to get it to work. Here's what I'm trying to do to a much larger file... A B 1 2 300 2 2 200 (hidden/filtered) 3 3 100 How do I set up a formula to get 2*300 + 3*100 = 900? Thanks. tinman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
| summing visible cells using SUMIF/SUMPRODUCT not SUBTOTAL | Excel Discussion (Misc queries) | |||
| sumproduct and visible cells | Excel Worksheet Functions | |||
| SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY | Excel Worksheet Functions | |||
| Help: Copying Visible Cells only to Visible cells! | Excel Programming | |||
Threaded Mode
