Hello,

I hope my query is a very easy one to create a solution.

I have a column of data. The data is not a number but a series of text from '011-020 & maybe 5 other range(s)/criteria of similar text, which would be in the same formula

I would like a countif or array formula that results in the text "Cleaning" to be created on an adjacent column if the cell contains any of the text in that range or blank as result if not

I than have a balance $ say 500.00 (in another cell) that I want to be reduced if that criteria above is valid/true. This balance is in another cell & there is another calculation result being conducted that gives a total on another column that this total would subtract from say column 'e' with a total amount used of $300.00 (this total is based another formula in the workbook), so the total based on the criteria above would now be showing as $200.00 balance

To add another criteria to this, there maybe five separate totals which are consisting of 5 difference individuals, & would setup within the above formula another criteria such as person A, B, C, D & E to be validated on as well as the item number, criteria & category. The categories maybe 'cleaning, crowns, x-rays, dentures, etc

Thank you

[TABLE="width: 949"]

Quantity

[/td]Item number(s)

[/td]Code category

[/td]Code family

[/td]Code person

[/td]Code benefit

[/td]Item quote

[/td]Item benefit

[/td]Total benefit

[/td]Conditions of benefit

[/td]1.00

[/td]011

[/td]Scaling

[/td]A

[/td]2

[/td]$ 41.00

[/td]$ 30.00

[/td]$ 30.00

[/td]A

[/td]$ -

[/td]$ -

[/td]$ -

[/td]$ -

[/td]$ -

[/td]$ -

[/td]$ -

[/td]$ -

[/td]$ -

[/td]Balance from WHICS

[/td]Balance (after benefits)

[/td]Total

[/td]

[TD="align: right"]$41.00[/TD]

[TD="align: right"]$30.00[/TD]

A Limits(s) remaining (

[/td]$ 300.00

[/td]$ 270.00

[/td]Lump sum

[/td]B Limits(s) remaining (

[/td]$ -

[/td]

[TD="colspan: 6"]Percentage return[/TD]

[TD="colspan: 2"]73%[/TD]

C Limits(s) remaining (

[/td]$ -

[/td]D Limits(s) remaining (

[/td]$ -

[/td]OOP

[/td]

[TD="colspan: 2"]$11.00[/TD]

E Limits(s) remaining (

[/td]$ -

[/td]F Limits(s) remaining family

[/td]$ 500.00

[/td]Not applicable

[/td]

[/TABLE]