risto76502
New Member
- Joined
- May 14, 2015
- Messages
- 9
So I have a formula on one sheet that will count each instance of the same word in the same cell on another sheet, but now I need it to do the same thing if other ranges meet certain criteria... The current formual works great, But I just need to tweak it a bit I have tried everything, and just cant seem to get it. My original formula is
=SUMPRODUCT(LEN('bueberry sales'!$W$2:$W$1000)-LEN(SUBSTITUTE(('blueberry sales'!$W$2:$W$1000),"blueberry","")))/LEN("blueberry")
I want this formula to do the same thing if range 'blueberry sales'!B2:B1000="fresh" and if 'blueberry sales'!W2:W1000="blueberry"
ANY HELP WOULD BE GREATLY APPRECIATED!!!!
=SUMPRODUCT(LEN('bueberry sales'!$W$2:$W$1000)-LEN(SUBSTITUTE(('blueberry sales'!$W$2:$W$1000),"blueberry","")))/LEN("blueberry")
I want this formula to do the same thing if range 'blueberry sales'!B2:B1000="fresh" and if 'blueberry sales'!W2:W1000="blueberry"
ANY HELP WOULD BE GREATLY APPRECIATED!!!!