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 |
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 |
All times are GMT +1. The time now is 01:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com