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

[Guest]

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.

 

[Rodrigo Ferreira]

If I understood, try this:

=SUMPRODUCT( (C8:C11="Retail") * (D811>30) * (D811<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";B9>30; B9 <60);C9;"")

 

[Don Guillett]

try
=SUMPRODUCT((A6:A9=2)*(C6:C9>30)*(C6:C9<60)*D69)

 

[Don Guillett]

re-read suggests

=SUMPRODUCT((b6:b9="retail")*(C6:C9>30)*(C6:C9<60)*D69)