sum wiht an if or vlookup?
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2006),--(B1:B100="purchase
d"),C1:C100)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Chip Smith" wrote in message
...
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--
|