If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I SUM column C IF Column A=X AND Column D=Y?
If you could follow that...
I have a number of columns of information for any given row. I would like to set up a sheet that will sum Column C for all rows IF Column A = {a given value} AND Column D = {a different given value}. I may even need to throw in that Column B = {another given value}. Can I do this and how? I've run across something about VLOOKUP, but I'm not sure how to make that work. I'm primarily a CAD operator making brief forays into Excel, and I keep thinking it has got to be easier than all the manual sorting I'm currently doing. I'm using Excel 2003 (on Windows XP SP2) |
Thread Tools | |
Display Modes | |
|
|