| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Skipping cells when using SUMPRODUCT function
I am trying to use the following function: SUMPRODUCT(--((E2:G2)E2)) to find
the number of positive changes in this series -- which works well. How would I do this for JUST E2 and G2 rather than E2, F2, and G2? Many thanks, Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying values but skipping empty cells | Excel Worksheet Functions | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
Threaded Mode
