Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
I have a worksheet called "data" which contains raw data that I need to
summarize. Column G contains the type of wigit (in text i.e. silver pipe), column E contains the date purchased. In another worksheet, same workbook I want to be be able to calcualte the number of silver pipes by month. Keep in mind that column E contains multiple instances per month. Data is also captured for 12 months of the year Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Curtis,
If you have XL2007 use the new Countifs function. As I don't, I suggest you look at the help files. There is also for this and other versions the SumProduct function, which I normally use. Assuming you have a header row in row 1 then it would look like this: =SUMPRODUCT(--(MONTH(Data!$E$2:$E$750)=1),--(Data!$G$2:$G$750="Silver Pipe")) The XL help files are not very informative, but this link provides some good info about this function. http://www.xldynamic.com/source/xld.SUMPRODUCT.html Also there are numerous instructional vids on YouTube which you may find useful. Just use the site search for Sumproduct or Countifs will result in a number of interesting lessons on how to use these functions. Regards Paul "Curtis" wrote in message ... I have a worksheet called "data" which contains raw data that I need to summarize. Column G contains the type of wigit (in text i.e. silver pipe), column E contains the date purchased. In another worksheet, same workbook I want to be be able to calcualte the number of silver pipes by month. Keep in mind that column E contains multiple instances per month. Data is also captured for 12 months of the year Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|