Hi,

Please help me out with the forumla.

Help with the forumla, whether it works with vlookup or IF conditions

Group Invoice Age Amount
1 Retail 1 550
2 Retail 35 600
3 Retail 45 325
4 system 25 485

For EX: If (line# 2 = Retail)& if (invoice age <60 & 30), the result
should be amount i.e 600

Do the needful.

If I understood, try this:

=SUMPRODUCT( (C8:C11="Retail") * (D8:D1130) * (D8:D11<60); E8:E11 )
But the result is 925 cause line #2 and line #3 are "Retail" and "Invoice
Age" are 30 and < 60

or if you want to check all the lines:

=IF(AND(A1="Retail";B930; B9 <60);C9;"")

--

Rodrigo Ferreira


"Igneshwara reddy" escreveu na
mensagem ...
Hi,

Please help me out with the forumla.

Help with the forumla, whether it works with vlookup or IF conditions

Group Invoice Age Amount
1 Retail 1 550
2 Retail 35 600
3 Retail 45 325
4 system 25 485

For EX: If (line# 2 = Retail)& if (invoice age <60 & 30), the result
should be amount i.e 600

Do the needful.

try
=SUMPRODUCT((A6:A9=2)*(C6:C930)*(C6:C9<60)*D6:D9)

--
Don Guillett
SalesAid Software

"Igneshwara reddy" wrote in
message ...
Hi,

Please help me out with the forumla.

Help with the forumla, whether it works with vlookup or IF conditions

Group Invoice Age Amount
1 Retail 1 550
2 Retail 35 600
3 Retail 45 325
4 system 25 485

For EX: If (line# 2 = Retail)& if (invoice age <60 & 30), the result
should be amount i.e 600

Do the needful.

re-read suggests

=SUMPRODUCT((b6:b9="retail")*(C6:C930)*(C6:C9<60) *D6:D9)

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...

try
=SUMPRODUCT((A6:A9=2)*(C6:C930)*(C6:C9<60)*D6:D9)

--
Don Guillett
SalesAid Software

"Igneshwara reddy" wrote in
message ...
Hi,

Please help me out with the forumla.

Help with the forumla, whether it works with vlookup or IF conditions

Group Invoice Age Amount
1 Retail 1 550
2 Retail 35 600
3 Retail 45 325
4 system 25 485

For EX: If (line# 2 = Retail)& if (invoice age <60 & 30), the result
should be amount i.e 600

Do the needful.