LinkBack URL
About LinkBacks
I need a formula in Excel 2003 to add a col based on three conditions
I need a formula in Excel 2003 to add a col based on three conditions
Formulas cannot add columns, formulas can only display a "result", an answer in the cell they are entered into.
To suggest a VBA solution, you will have to describe the entire process/logic to follow, and provide a sample workbook. Click GO ADVANCED and use the paperclip icon to post up your workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
No I did not mean add I ment to total a column
OK, then based on the information you've provided so far...I have no idea.
Joking aside, a sample workbook showing us what you're wanting to do should make this a quick solve. Click GO ADVANCED and use the paperclip icon to post up your workbook.
As a starting point, it sounds like a job for sumproduct, e.g., =Sumproduct((A1:A10="Bob")*(B1:B10=5)*(C1:C10="New York")*(D1:D10)), which would sum D1:D10 if columns A:C met all of those conditions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks