Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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-- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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-- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |