Hi,
i have about 6 + columns, i.e data, category, amount and name.
I need to know how many unique names are in a column provided other conditions have been met. i.e.
How many unique names are there, in January,under water catgory, who paid more than $0?
=countifs(a1:a7000,"=january",b1:b7000,"=water",c1,c7000,">0") =46
I want to add another formula that will count how many unique names are in column d, provided the above conditions have been meet. How can i do that easlity, as i have about 30 categories to do the same thing to? Can excel do that?
Please help and thanks for your time and effort
i have about 6 + columns, i.e data, category, amount and name.
I need to know how many unique names are in a column provided other conditions have been met. i.e.
How many unique names are there, in January,under water catgory, who paid more than $0?
=countifs(a1:a7000,"=january",b1:b7000,"=water",c1,c7000,">0") =46
I want to add another formula that will count how many unique names are in column d, provided the above conditions have been meet. How can i do that easlity, as i have about 30 categories to do the same thing to? Can excel do that?
Please help and thanks for your time and effort