OddProject
Registered User.
- Local time
- Yesterday, 21:23
- Joined
- Nov 24, 2009
- Messages
- 67
Hi guys, easy one for you.
I have 4 colums:
the 1st I have a unique code.
the 2nd i have the date log
3rd a colum with 4 types (red, blue, green etc) for example.
4th just a title.
I need to count the number of colours in colum 3 in each month (Aug, sept, oct, Nov, Dec, Jan and Feb.
I know i need a nested formula = countIf(C2,C134,"Blue") Where B =>01/08/2009 AND =<30/08/2009.
Get what I mean?
Many thanks
I have 4 colums:
the 1st I have a unique code.
the 2nd i have the date log
3rd a colum with 4 types (red, blue, green etc) for example.
4th just a title.
I need to count the number of colours in colum 3 in each month (Aug, sept, oct, Nov, Dec, Jan and Feb.
I know i need a nested formula = countIf(C2,C134,"Blue") Where B =>01/08/2009 AND =<30/08/2009.
Get what I mean?
Many thanks