Monday, April 15, 2013

yogi_Count Number Of Parts Beginning With Specified Characters Transacted In A Specified Month


                                          Google Spreadsheet   Post  #1128
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 15, 2013
user MikeGodfrey13  :(http://productforums.google.com/forum/?zx=kaquw4uxiqns#!topicsearchin/docs/MikeGodfrey13/docs/pwr6116ec8U)
Google Spreadsheets Formula
I'm having trouble tiring to figure out how to do the following:

I need to look in the part column and find any thing that starts with EN
Then I need to look in the date column and count it if the date falls in January.

Expected results from my sample data below would be 2


Part #                     Date
EN12345              1/13/13
EE43247              1/4/13
MN78427              3/27/13 
EN19087              1/23/13
ME98768              2/19/13
EN56399              3/22/13

Chrome Version 26.0.1410.64 m  on Win XP SP3 

Any ideas or examples, Thank you in advance for any help
-------------------------------------------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem


No comments:

Post a Comment