To the demigods of SUMPRODUCT, HEAR ME!

S

sexynumbers

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...
 
A

Arvi Laanemets

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)Arvi Laanemets<[email protected]> wrote in messageyo! 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...>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

take the green pill or take the SUMPRODUCT? 3
a second call for the goddezzez and godz of SUMPRODUCT 2
sumproduct problem (another one) 3
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Macro to match 2 column values in different sheets 1
Does complicated sumproduct formula crashes excel? 7
MACRO TO LOOKUP AND SUM 3
Two Matches, then Sumproduct of Values 16

Top