Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf, SumIf formula ques.
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 |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - I need to combine both a SUMIF and COUNTIF into one formula | Excel Worksheet Functions | |||
A formula maxif, similar with sumif or countif | Excel Worksheet Functions | |||
Countif, Match or Sumif Formula | Excel Worksheet Functions | |||
Which formula to use? countif, sumif, sumproduct | Excel Discussion (Misc queries) | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |