I am creating a summary within a large spreadsheet and want to be able to show the total number of items that meet two criteria.
Criteria A is in a range in one column, and Criteria B in another. Both of these criteria are in the same sheet but one is Text and one is a checkbox.
Criteria A is a type and Criteria B is checkbox to show whether that type is a particular version number e.g box checked means 'Yes'. The purpose of the summary and why I want to calculate this is because I have a number of 'Types' with a number of 'Versions' and I want to see how many of each.
I've tried a number of formula, COUNTIFS, DCOUNTA, ARRAY - stabbing around to see if anything will work...no joy!
If there is a way to do this with the checkboxes remaining that would be great, but I guess I could also change the second criteria to a numeric value. But I am still not sure which formula for the two criteria together to get the output I want.
Any help appreciated.