| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To the demigods of SUMPRODUCT, HEAR ME!
yo! goddessez & godz!
if you know SUMPRODUCT i hope that you can help out a hapless mortal... =SUMPRODUCT(--(Sheet2!$G$2:$G$65536=$G$7),--(Sheet2!$L$2:$L $65536=?????),--(Sheet2! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ $E$2:$E$65536="BA"),Sheet1!$M$2:$M$65536) Basically for collumn L, i am trying to ask for all values from 1000-1999. How do I do this? Mucho Danke... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To the demigods of SUMPRODUCT, HEAR ME!
Hi
=SUMPRODUCT(--(Sheet2!$G$2:$G$65536=$G$7),--(Sheet2!$L$2:$L$65536=1000),--(Sheet2!$L$2:$L$65536<2000),--(Sheet2!$E$2:$E$65536="BA"),Sheet1!$M$2:$M$65536)A rvi wrote in oglegroups.com... yo! goddessez & godz! if you know SUMPRODUCT i hope that you can help out a hapless mortal... =SUMPRODUCT(--(Sheet2!$G$2:$G$65536=$G$7),--(Sheet2!$L$2:$L $65536=?????),--(Sheet2! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ $E$2:$E$65536="BA"),Sheet1!$M$2:$M$65536) Basically for collumn L, i am trying to ask for all values from 1000-1999. How do I do this? Mucho Danke... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Did you hear that Frank? Kevin wants you to become Alias #3, Just FYI | Excel Discussion (Misc queries) | |||
| Why can I not hear the words recorded on powerpoint? | Excel Discussion (Misc queries) | |||
| Event (BeforeSave) - How to test VBA code? Dave P. can you hear me now? | Excel Discussion (Misc queries) | |||
| Saving so others can hear linked sound | Excel Discussion (Misc queries) | |||
| VBE takes two tries to hear me clearly... | Excel Programming | |||
Linear Mode
