Error in formula

[Saransh]

Hello Everyone

A B
1 10500 5000
2 12600 7000
3 10500 2000
4 23000 1000
5 27000 2500

i want that the value in A column if it is between 10000 and 20000 their amount in column B should show the sum in any other column

i have tried using:

=SUM(IF(AND(A2:A6,">10000",A2:A6,"<20000"),Sheet1!B2:B6))

 

[Jonmo1]

Welcome to the board..

Can't use AND in an array like that..
Try

=SUM(IF((A2:A6, > 10000)*(A2:A6, < 20000),Sheet1!B2:B6))

Entered with CTRL + SHIFT + ENTER

 

[VoG]

Hi. Try

=SUMPRODUCT(--(A2:A6>=10000),--(A2:A6<=20000),B2:B6)

 

[T. Valko]

Hello Everyone

A B
1 10500 5000
2 12600 7000
3 10500 2000
4 23000 1000
5 27000 2500

i want that the value in A column if it is between 10000 and 20000 their amount in column B should show the sum in any other column

i have tried using:

=SUM(IF(AND(A2:A6,">10000",A2:A6,"<20000"),Sheet1!B2:B6))

Try one of these...

Use cells to hold the criteria:

• D2 = 10000
• E2 = 20000

This formula will work in any version of Excel.

=SUMIF(A2:A6,">"&D2,B2:B6)-SUMIF(A2:A6,">="&E2,B2:B6)

This formula will work in Excel versions 2007 and later.

=SUMIFS(B2:B6,A2:A6,">"&D2,A2:A6,"<"&E2)

 

[Saransh]

hi guys,

thanks

 

[Saransh]

hi guys,

can anyone explain that how can i unprotect a password protected cell.

i have forgotten password.

thanks

 

[Joe4]

I am sorry, but the previous reply has been removed. Posts describing how to break passwords are against our rules, since they can be used for malicious reasons (see rule #11 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

 

[T. Valko]

I am sorry, but the previous reply has been removed. Posts describing how to break passwords are against our rules, since they can be used for malicious reasons (see rule #11 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

OK, sorry about that!