countif calculation problems
Posted by Karan on January 11, 2001 1:53 PM
I need to perform a countif calculation based on two sets of criteria. I have tried using if() statements and countif() statements without success. I have tried dcount() which works fine for the total, but I need the data broken down further.
Column A contains "Area" and Column AI contains "Month". I need a formula that will count the number of entries that contain value "X" in "Area" [countif(a3:a184,"X")] and value "Y" in "Month" [countif(ai3:ai184,"Y")]. I have tried nesting the countif also without success. Seems a relatively simple task, but...
Any help is greatly appreciated.