Help with the forumla, whether it works with IF condition or Vlook
 

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.

Help with the forumla, whether it works with IF condition or Vlook
 

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.

Help with the forumla, whether it works with IF condition or Vlook
 

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.

Help with the forumla, whether it works with IF condition or Vlook
 

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.