"Krish" wrote in message
...
I have a list in a spreadsheet as follows. I want a formula to fill the
Criteria column. The condition should be
Invoice dollars should be less than $ 200 and
if there are two Invoices for the same customer and if the sum of all
Invoices is still less than $ 200, it should reflect as "TRUE" for both
Invoices.
If the dollar amount of an Individual Invoice or sum of all Invoices for a
customer is greater than $ 200, it should reflect as "FALSE"
InvoiceCustomerSalesCriteria
W112311CRE100799.15
W112344CRE100185.42
W112345DRW200199.49
W112452HLE300129.95
W112457HLE30041.54

How can I accomplish the multiple conditions in one formula?
----------------------------------------

Name Customers the Customer range
Name Sales the Sales range

=IF(SUMIF(Customers,Customers,Sales)<=200,TRUE,FAL SE)

Ciao
Bruno