View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chip Smith
 
Posts: n/a
Default sum wiht an if or vlookup?

I have a spreadsheet with lots of data. i'm trying to create a number chart
dependant on certain parts of data. the chart will be based off differnt
types of data and for each month. this chart will be kept on a seperate
sheet. basically for january it will search for all the parts purchased and
sum those, then it will search for all parts that are renting and sum those
and it will do that for each month. can i write a formual for this like an
"if" or "vlookup" or something of that nature to sum them?
--
--Chip Smith--