Need help with formula... please help!

[danmen]

please take a look! .... thx. =))))


http://www.pbase.com/frankcoti/image/110663885/original.jpg

 

[Domski]

Try:

=SUMPRODUCT((INDIRECT("Sheet1!A"&B3&":A"&B4)>B1)*(INDIRECT("Sheet1!A"&B3&":A"&B4)< B2)*(INDIRECT("Sheet1!B"&B3&":B"&B4)))<?XML:NAMESPACE PREFIX = B2)*(INDIRECT("Sheet1!B"&B3&" /><B2)*(INDIRECT("Sheet1!B"&B3&":B"&B4)))< p>

Dom
</B2)*(INDIRECT("Sheet1!B"&B3&":B"&B4)))<>

 

[schielrn]

Maybe try:

=SUMPRODUCT(--(Sheet1!A2:A13 >= B1),--(Sheet1!A2:A13 <= B2),--(ROW(Sheet1!A2:A13) >= B3),--(ROW(Sheet1!A2:A13) <= B4),Sheet1!B2:B13)

I believe you are wanting < = and > = and not just < and >, at least for the row part.

Hope that helps.

 

[danmen]

Re: Need help with macro - plz read second question inside!! thx. =))

thx. guys, I tried the first formula and it worked great so i didn't bother with the second one =))

SECOND QUESTION!!

I also have another question having to do with macros: I have a workbook with many sheets but I want limit which macros can be launched from the active sheet.... can this be done or does the alt+key always launch the macro regardless which sheet I'm in?

 

[schielrn]

Re: Need help with macro - plz read second question inside!! thx. =))

The Alt+F8 will always let you see all the macros within the workbook unless they are marked as private.

You could put an if statement in your macro code, that ended the amcro if it wasn't the correct sheet. Maybe something like:

if activesheet.name = "Sheet1" or activesheet.name = "Sheet2" then end

or if you want to include sheets it could be:

if activesheet.name <> "Sheet1" or activesheet.name <> "Sheet2" then end

Hope that helps.