| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Skipping cells when using SUMPRODUCT function
Jason,
You could use =SUMPRODUCT(--(MOD(COLUMN(E2:G2),2)=1),--(E2:G2E2)) but why not just =--G2E2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jason" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Skipping cells when using SUMPRODUCT function
Bob,
Thanks. Sometimes simple is best. "Bob Phillips" wrote: Jason, You could use =SUMPRODUCT(--(MOD(COLUMN(E2:G2),2)=1),--(E2:G2E2)) but why not just =--G2E2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jason" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
