Wednesday, April 17, 2013

yogi_Count in Sheet2 Number of Projects Completed By Each Manager And Total Number of Projects By Each Status Category

                                          Google Spreadsheet   Post  #1135
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 17, 2013
user Stephen Ch :(!searchin/docs/anandvarma%7Csort:date/docs/f3IGhGQiB5k/HKKH0QO7tu0J)
Using countIF function on two columns of cells

I am trying to count the number of occurrences of values in two rows of cells but I cannot get the syntax correct.

In logical terms the formula would look something like this:  =countIF(sheet1!S2:S84,"Value A") AND (sheet1!D2:D84,"Value B") .  

The result would obviously just be the count of cells in Row S containing Value A and Row D that contain "Value B"

Can someone advise if this is possible and if yes, how to achieve it.



Thanks for the response.
Not sure how I share the sheet with you unless I have your email address so I have attached an excel formatted version.  hopefully you can convert into sheet format and test from there.
Attachments (1)
Google Sheet Test (1).xlsx
4 KB   View   Download
following is a solution