Hi,
I am looking for a formula to count cells that are not empty in a pivot. The complication is that it needs to count cells/rows across multiple columns.
My query would be something like the following: If anything in rows 2 to 30 in the columns D,J, and K, put "1" in this cell. I will then have a total at the bottom counting how many fit the criteria ie rows from those specific columns with a combined value greater than 1.
Is this possible? TIA
I am looking for a formula to count cells that are not empty in a pivot. The complication is that it needs to count cells/rows across multiple columns.
My query would be something like the following: If anything in rows 2 to 30 in the columns D,J, and K, put "1" in this cell. I will then have a total at the bottom counting how many fit the criteria ie rows from those specific columns with a combined value greater than 1.
Is this possible? TIA
