Hi Richard,

Thank you. I´m making a reporting table. Basically it entails counting alot of values meeting different combinations of conditions. For example count only if one column is F when columns A,B or C has anything entered in it and when the entry is for a date falling between two dates etc. So it is basically counting with alot of IFs.

I suppose COUNTIFS would better suit my purpose? Would you know the most concise reference on how to use it with multiple conditions like AND OR NOT?

Many thanks,

Roger