View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Minx Minx is offline
external usenet poster
 
Posts: 10
Default 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)