Formula Help

[Curtis]

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

 

[Paul]

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