Tuesday, November 20, 2012

yogi_Count Number Of Battle Ready Ships From Source Sheet Meeting Multiple Criteria Specified In Target Sheet

                                          Google Spreadsheet   Post  #879
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 20, 2012
user Zachary.Burrows said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/bpuqtXzClrg)
COUNTIF Multiple Conditions
I play an online game based around pirating and blockading islands etc. and we share a ship list via Google Drive so we can coordinate attacks etc. I have made a copy of the doc for public viewing so you can see what I am talking about.

You will see on the Summary tab it counts ships of different classes in the Total tab using a COUNTIF, an example of what I need for Cell C2 is:

Count entries on 'Ship List' where B:B=Sloop & G:G=Battle Ready

I can't seem to get my head around how to phrase the formula and would be grateful for some assistance.


Thanks in advance

 following is a solution to the requested part of the problem