Hi,

In the criteria column, enter the following formula
I have worked with the following example. I have entered the data on names
and amounts. True or false is the output.

Ashish 1 True
Ashish 5 True
Mathur 3 True

=IF(SUMIF($B$4:$B$6,B4,$C$4:$C$6)<200,"True","Fals e")

Please adjust the example to yourt needs.

Regards,

"Krish" wrote:

I have a list in a spreadsheet as follows. I want a formula to fill the Criteria column. The condition should be
a.. Invoice dollars should be less than $ 200 and
b.. 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.
c.. 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"
Invoice Customer Sales Criteria
W112311 CRE100 799.15
W112344 CRE100 185.42
W112345 DRW200 199.49
W112452 HLE300 129.95
W112457 HLE300 41.54

How can I accomplish the multiple conditions in one formula?