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     www.energyefficientbuild.com.    Apr 17, 2013
user Stephen Ch :(http://productforums.google.com/forum/?zx=hxepajen7cjc#!searchin/docs/anandvarma%7Csort:date/docs/f3IGhGQiB5k/HKKH0QO7tu0J)
Using countIF function on two columns of cells
Hi

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

Stephen

---

Hi

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