Calculation of instances a value is found in a series of cells

=?Utf-8?B?RFNCVFg=?=

Guest

Posts: n/a

24th Feb 2006

I have several objects which over several months will change color several
times.
I want to tally at the bottom of my worksheet the total number of instances
of green blue and red for each month. i.e For 10 objects in month one I have
4 green 4 blue and 2 red. The following month I have 5 green, 4 blue and 1
red.

If I code g for green, b for blue and r for red in each cell, how do I
tally these "letters" at the bottom of each month??
Thanks in advance

« Pivot Table Groups | Re: Calculating an average based on 2 and 3 criteria »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy an intial cells contents into the next series of blank cells ina column	freeriderxlt	Microsoft Excel Discussion	2	25th Aug 2009 07:47 AM
Custom Label for data series with calculation	fcmedina78	Microsoft Access Reports	0	21st Jun 2008 05:36 PM
Time series calculation	RD Wirr	Microsoft Excel Worksheet Functions	7	5th Feb 2008 12:46 PM
Two Instances of explorer.exe Found!!!	Jerry McMorran	Windows XP General	12	28th May 2004 01:34 AM
Do a calculation on a series of dates linked to a case	Pat	Microsoft Access Queries	3	2nd Mar 2004 09:12 PM