Briscoefilms
New Member
- Joined
- Nov 13, 2015
- Messages
- 7
Hi guys, this ones got me stumped. I've been through some old posts referencing similar, but im still having no luck.
So I'm trying to calculate the number of times "Dec" is entered in a column, whilst also have "No" listed in another column. However, the ranges differ considerably from each other.
'Referral Data'!$W$127:$W$999,"Dec" being the range I need to draw the amount of Dec from.
'Referral Data'!$X$671:$X$731,"No" being the range I need to cross reference for No results.
So I want to achieve the amount of names Dec and No both apply against. I will also have to do the same with Yes, but hopefully sorting this one out, will mean that will too.
So I'm trying to calculate the number of times "Dec" is entered in a column, whilst also have "No" listed in another column. However, the ranges differ considerably from each other.
'Referral Data'!$W$127:$W$999,"Dec" being the range I need to draw the amount of Dec from.
'Referral Data'!$X$671:$X$731,"No" being the range I need to cross reference for No results.
So I want to achieve the amount of names Dec and No both apply against. I will also have to do the same with Yes, but hopefully sorting this one out, will mean that will too.