Posted to microsoft.public.excel.worksheet.functions
|
|
CountIf, SumIf formula ques.
Sumproduct gives you more control than countif or sumif. Read this:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Regards,
Ryan--
--
RyGuy
"jmfrank" wrote:
I have a tab with data, I've made a summary tab where I've used CountIf and
SumIf to total the info by state. I want to exclude three lines of data from
my count, how do I do that?
--
Joan
US Bank
|