sandwichgirl
New Member
- Joined
- Aug 13, 2007
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
Hi
I've tried searching for a function that will calculate this answer, but am having trouble finding anything relevant relating to multiple ranges.
I've named my ranges to reduce my confusion and they are called onecraft, twocraft, threecraft, fourcraft etc (each is on a different worksheet and each contains a different number of rows). I want to count up how many different prices are contained across these ranges (whilst ignoring duplicates). I've tried sumproduct/countif, but from what I've read the countif can't cope with multiple ranges.
Is there a way to do this?
thanks in anticipation of my reduced frustration.
sandwichgirl
I've tried searching for a function that will calculate this answer, but am having trouble finding anything relevant relating to multiple ranges.
I've named my ranges to reduce my confusion and they are called onecraft, twocraft, threecraft, fourcraft etc (each is on a different worksheet and each contains a different number of rows). I want to count up how many different prices are contained across these ranges (whilst ignoring duplicates). I've tried sumproduct/countif, but from what I've read the countif can't cope with multiple ranges.
Is there a way to do this?
thanks in anticipation of my reduced frustration.
sandwichgirl