|Hi i am trying to do a count if for multiple criteria but am running into problems.|
I have a spreadsheet with multiple tabs and am running queries on a summary tab. On the tabs I am trying to report on the first column has the department name and the second column has a description of which some items contain the letters BB at the end.
I can use the COUNTIF function to get all the items ending in BB with the following =COUNTIF('May-11'!B:B,"* BB") and I can report on the count of departments (regardsless of ending in BB) with the following =COUNTIF('May-11'!A:A,A2) where A2 is referencing a list of the departments on the summary page.
In summary I would like to get any item in column B ending in BB and split this up by department in column A.