Wednesday, February 27, 2013

yogi_Compute The Number of Attendees (Row By Row And Total) From Their Initials Entered As Comma Separated Values In Another Column


                                          Google Spreadsheet   Post  #1057
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 27, 2013
user heathnewton-felix said:(http://productforums.google.com/forum/?zx=fuio1wk47f5e#!category-topic/docs/spreadsheets/weRJUfT8en0)
Counting specific text in cells
I was just wondering if this could be done.

I have a column called "confirmed attendees" and a column called "# of attendees".

In 'confirmed attendees' column, there would be a number of different initials. For example - ab,cd, ef, gh etc.

Is it possible to have '# of attendees' count the specific text in the 'confirmed attendee's column?

For example:

ab = 1
ab cd = 2
ab gh ef = 3?

Can this be done?

Thanks so much for any help!!
---

I stripped down some information, but this what the spreadsheet is like.

a-i = just event info

I usually put initials in the J column separated by spaces (doesn't really matter) - en, th, br, rk, js and fc to be exact.

I would like the # of attendees to reflect the number of initials.  SO if there's ag and en, then it would be 2. If there is en th br, then it would be 3.

I will then take that and multiply it by the corresponding I column to give a total value in L.

Does that help?

Thanks Yogi.
-----------------------------------------------------------------------------------------------------------------
in the following I have created a computed range K5:K where I compute the number of attendees and cell K5 also delineates the Total # of Attendees ... the computed range updates automatically and dynamically as new information is entered in range J5:J