software

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
quot;ifquot; or quot;vlookupquot; or something of that nature to sum them?
--
--Chip Smith--=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2006),--(B1:B100=quot;purchase
dquot;),C1:C100)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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