Hello,
I'm trying to make a formula that will check 3 columns for 3 different criteria. The first column that should be checked first has the criteria of dates between a date range, ie. will the date in a cell in column A fall in a certain month. The second and third column hold data that is to be counted if it also falls within a criteria. Second column is a measure of temperature (70 degrees +or- 10) and the third is a measure of humidity (simple check if its over 70%). I have been able to create a formula that does this but I am having difficulty getting it to display blank instead of 0 if there is no data. The way I want the formula to display is if there are no entries in the date column for for a certain month (this scenario would be for months that havent happened yet) it should display blank instead of 0. For months where there is an entry in the date column but none in the temperature or humidity column (months that have happened but have not had any days where temp or humidity has exceeded the allowed values) it should display 0. This data is then pulled into a cell that displays the % of days in the month where it was within acceptable values and then this data is pulled to another workbook where it is a metric that is tracked, and I don't want it to display anything for months that haven't happened yet.
Formula before attempting to display blank : (months january to april still have this formula)
As you can see, the second formula is displaying blank no matter what. (months may to december)
exc.PNG
Bookmarks