Please Help
 

Hi all,

I really would like to learn how I can write below written algorithm
as a formula in excel?

IF From A1 to A4000 = "EXPORT" and IF From B1 to B4000 = "Google Co."
then SUM from U1 to U4000

It will just sum all numbers in column U if BOTH OF IF FORMULAS are
consistent with the required TEXTS.

It is like "How to see Total Export Invoice Amount for Google Co. "
A Column is used for: if DELIVERY is IMPORT or EXPORT
B Column is used for: the Company which invoice will be charged
C Column is used for the invoice amounts

Please Help
 

One way:

=SUMPRODUCT(--(A1:A4000="EXPORT"),--(B1:B1000="Google Co."),
U1:U1000)

In article . com,
wrote:

Hi all,

I really would like to learn how I can write below written algorithm
as a formula in excel?

IF From A1 to A4000 = "EXPORT" and IF From B1 to B4000 = "Google Co."
then SUM from U1 to U4000

It will just sum all numbers in column U if BOTH OF IF FORMULAS are
consistent with the required TEXTS.

It is like "How to see Total Export Invoice Amount for Google Co. "
A Column is used for: if DELIVERY is IMPORT or EXPORT
B Column is used for: the Company which invoice will be charged
C Column is used for the invoice amounts