Wednesday, May 1, 2013

yogi_Compute Row By Row Count Of Specified Strings In Multiple Ranges Spread Over Several Sheets

                                          Google Spreadsheet   Post  #1165
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 01, 2013
user dlgarbett  (!category-topic/docs/spreadsheets/GNxGPYa_6Vs)
countifs in google spreadsheets
I want to count the number of times a particular string appears in specific rows on my spreadsheets.

see sheet "totals" B119 my formula if it were in excel would be

I have used countif(range,"string")+countif(range,"string")................before for this and I can use it here as well, but I think there must be an easier way.

Please help!

As of now (May-01-2013) Google spreadsheet does not support the use of COUNTIFS functions ... however have a look at the following solution to the problem