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.
Bookmarks