Hello all,
Ok, I feel like I'm missing something really easy, but I'm trying to count the number of times a particular color was washed after the date it was stained. This is the formula I am using: =COUNTIFS($B$2:$B$5,$B$2:$B$5<$C$2:$C$5,$A$2:$A$5,A2)
So, basically for those who don't want to open the file, I'm trying to compare two set of ranges on a 1:1 basis.
Any help would be greatly appreciated. Thank yoU!
What are your expected results?
Take the colour purple for example ... it was stained twice... on once occasion it was washed prior to staining (row 2) and on the second occasion it was washed on the same day so is the answer 0 for purple?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Darn, sorry... I meant for C2 to read "4/15/2015" - so the answer would be 1 for purple and 1 for red. Pink would be 0.
and what about row five? where it was stained and washed on same day? not included in count?
No, not included in the count. Only if it was washed after it was stained.
ok - i'll have a crack at it!! I'll try and do it asap - im no expert but will have a bash!
Thanks!! I really appreciate it!
=SUMPRODUCT(($A$2:$A$5=B8)*($C$2:$C$5>$B$2:$B$5)) in c8 copy down - sorry for the delay, held up at work
This worked like a charm. Thank you so much for taking time to work this out. I didn't even think to use Sumproduct.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks