Hi friends,
I named colum A entirly as "ColA" and column B entirly as "ColB". I used these range names in one of the arrary formula like follows:
{=sum(if(ColA="A", if(ColB="B", 1,0),0))}
But it returns #NUM! error. Please help how to resolve this error. I thought range names work very well in arrary formulas
Ramana[/url]
I named colum A entirly as "ColA" and column B entirly as "ColB". I used these range names in one of the arrary formula like follows:
{=sum(if(ColA="A", if(ColB="B", 1,0),0))}
But it returns #NUM! error. Please help how to resolve this error. I thought range names work very well in arrary formulas
Ramana[/url]