Conditional formatting. I want to add all those values where column name is
F02 and row name is Federal in a given area not the whole worksheet.

Seema,

Please provide a little more information. Is the column name mentioned in
Row1? Is the Row name mentioned in Column A?

Thanks
Gaurav

"Seema" wrote in message
...
Conditional formatting. I want to add all those values where column name
is
F02 and row name is Federal in a given area not the whole worksheet.

Read this:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards,
Ryan--

--
RyGuy


"Seema" wrote:

Conditional formatting. I want to add all those values where column name is
F02 and row name is Federal in a given area not the whole worksheet.