Hi
For the life of me i cant work this out
I want to have it count certain cells if it has the Word "Not Bought" but if it has no cells with "Not Bought"
it inputs "0" which is correct but I would like instead of "0" it puts the word "Complete"
here is what i tried
=COUNTIFS(Via!A2553:A19999,"Not Bought",Via!AN2553:AN19999,"18"),"Complete")
So it matches up all not bought for week 18 but it puts 0 and love to replace that with word "Complete"
but also count "not bought" if that week 18 had say 2 not boughts it woud put in number "2"
Thank you
For the life of me i cant work this out
I want to have it count certain cells if it has the Word "Not Bought" but if it has no cells with "Not Bought"
it inputs "0" which is correct but I would like instead of "0" it puts the word "Complete"
here is what i tried
=COUNTIFS(Via!A2553:A19999,"Not Bought",Via!AN2553:AN19999,"18"),"Complete")
So it matches up all not bought for week 18 but it puts 0 and love to replace that with word "Complete"
but also count "not bought" if that week 18 had say 2 not boughts it woud put in number "2"
Thank you