| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a second call for the goddezzez and godz of SUMPRODUCT
....i think my first post must have been lost down the rabbit hole...
I have this function: =SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7),--(Sheet1!$L$2:$L $65536= ? ? ?),Sheet1!$M$2:$M$65536) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Column L is full of numbers from 0 to 9999, the second expression in the formula needs to call up all numbers in Column L from 1 to 3999 ONLY. . . oh, ye who are so powerful, this mortal requests the correct syntax... if you please... T H A N K S ! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a second call for the goddezzez and godz of SUMPRODUCT
Hi
Try =SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7), --(Sheet1!$L$2:$L$65536=1), --(Sheet1!$L$2:$L$65536<=3999), Sheet1!$M$2:$M$65536) -- Regards Roger Govier wrote in message oups.com... ...i think my first post must have been lost down the rabbit hole... I have this function: =SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7),--(Sheet1!$L$2:$L $65536= ? ? ?),Sheet1!$M$2:$M$65536) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Column L is full of numbers from 0 to 9999, the second expression in the formula needs to call up all numbers in Column L from 1 to 3999 ONLY. . . oh, ye who are so powerful, this mortal requests the correct syntax... if you please... T H A N K S ! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a second call for the goddezzez and godz of SUMPRODUCT
Try this:
=SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7),--(Sheet1!$L$2:$L$65536=1),--(Sheet1!$L$2:$L$65536<=3999),Sheet1!$M$2:$M$65536) HTH, Elkar " wrote: ....i think my first post must have been lost down the rabbit hole... I have this function: =SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7),--(Sheet1!$L$2:$L $65536= ? ? ?),Sheet1!$M$2:$M$65536) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Column L is full of numbers from 0 to 9999, the second expression in the formula needs to call up all numbers in Column L from 1 to 3999 ONLY. . . oh, ye who are so powerful, this mortal requests the correct syntax... if you please... T H A N K S ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Call | Excel Discussion (Misc queries) | |||
| Reference Call | Excel Discussion (Misc queries) | |||
| I'm not sure what you'd call it, but is it possible to do this? | Excel Discussion (Misc queries) | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| Don't know what to call what I need? | Excel Worksheet Functions | |||
Linear Mode
