I am hoping someone might be able to help me here. I think I am just missing something stupid, because I can get it to work... almost. Here is my situation:
I have a spreadsheet that has information constantly being adding to it. I want to analyze this data on a continous basis. One of the areas I want to be able analyze deals with counting the number of cells, based of from mulitiple criteria. However, I am able to get this array formula to work: {=SUM((IF(DataBase!A2:A14=B3,1,0)*(IF(DataBase!L2:L14="PASSED",1))))}, but only if the cells selected are populated.
My question is, how do I make this formula work for an entire column that has information consently being added, or is there a better way for me to accomplish this same thing with a marco or another formula?
Thanks in advance
Bookmarks