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

Hi:

Try this:

=if(and(countif(A1:A4000,"EXPORT"),countif(B1:B400 0,"Google Co.")),
SUM(U1:U4000),"")


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


" 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

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


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
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

Xl 2007

=SUMIFS(U:U,A:A,"EXPORT",B:B,"Google Co.")


" 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