Hi,
The SUMIF syntax is
SumIf( range, criteria, sum_range )
What I want to do is to use a range as the criteria.
Unfortunately the criteria I need is a large number of explicit values,
rather than being able to use wildcards like 'R*' or whatever. I have
therefore created a range which holds all of the criteria values. Is there
any way I can tie this into the SUMIF function, so that if the value finds a
match in the criteria range, then its evaluated to true and then does the
usual summing?
Manythanks in advance.
Andy