Link to home
Start Free TrialLog in
Avatar of Simon Raine
Simon RaineFlag for United Kingdom of Great Britain and Northern Ireland

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
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial