I have a table with values 1 and 2 in column B and I wish to know what the
results in columns B to X are based on this i.e If column A equals 1 and
column B equals 1 then I want to return a count of 1. And so on: if column A
equals 1 and column B equals 2 then return a count of 1. Can I also do this
for ranges if column C equals 10-20 and column B equals 1 then return a count
of 1. I have tried SUMIF, AND and IF in the Help but can't understand how to
the above?

Thanks for the help.