How to sumif with criteria

Dear Friends,

PFA the file for your reference.

I the file, in col. D I need to give the criteria (given in sheet).

Logic is that if the sumif is 0, then it should give "Sold", else "Not sold".

eg.
For B3 and B4, sumif (col E) =0, "Sold"
For B3 to B6, sumif (col E) =0, "Sold"
For B3 to B9, sumif (col E) =0, "Sold".

Is there any formula which can return the desired output ? The database huge. So doing it manually is very time consuming.

Please assist.

Dear alansidman,

The formula is failing if I am dragging down the formula.
I am getting the desired output.

Please assist.

Originally Posted by bebo021999

I am in doubt that there should be more categories other than "arif ce 15000 75" in column E, and sold qty should be equal/or smaller than purchased Qty. Is it possible?
Does it require FIFO rule? (First in first out)

Hi Bebo,
U are right.
There will be more catagories.
Sometimes sold qty might be less than purchase qty also.
It will also require FIFO rule.

Please assist.

Dear Bebo,

PFA the revised sheet.
I have added more rows and few more categories.


Please assist.

I suggest you should arrange your data as shown in the attached.

Hi John,
I wish I could.
This data is system generated.

Please assist.

The only option I can offer is to use the columns I created as "helper" columns as you need to process the data by item type.