Simon Raine
asked on
Count No of Rows Meeting multiple conditions without row formula
I have written a formula that displays if two conditions are met:
1) if column C = "FRA in date"
2) if column A and column B have dates that are NOT in the same month
Formula: =IF(C2="FRA in date",IF(MONTH(A2)<>MONTH( B2),"Yes", "No"),"N/A ")
I have then copied this formula all the way down the data set.
I have a countif formula on a separate tab that counts how many of the rows above are yes
Formula: =COUNTIF('Block Level'!D:D,"Yes")
I would like to just have one formula to provide me with the answer, i.e. not copying the first formula all the way down, just answer within the formula on the separate tab.
Thanks
Simon
Data.xlsx
1) if column C = "FRA in date"
2) if column A and column B have dates that are NOT in the same month
Formula: =IF(C2="FRA in date",IF(MONTH(A2)<>MONTH(
I have then copied this formula all the way down the data set.
I have a countif formula on a separate tab that counts how many of the rows above are yes
Formula: =COUNTIF('Block Level'!D:D,"Yes")
I would like to just have one formula to provide me with the answer, i.e. not copying the first formula all the way down, just answer within the formula on the separate tab.
Thanks
Simon
Data.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.