Formula Required to Count Rows only if condition is meet or else dont count and update the formula cell.
For Example:-
IN D1 I Need to add formula as given below:-
IF A1=B1, then Count Row C:C or else dont Count the result keep existing count as it is.
So, this is what you want based on your image:
If Class = Class Teacher (FALSE), count the rows in column C.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please ignore that Image,
Please refer Attached Sample excel.
I want - IF E1 = A7, then Count E3:E86 in B7 or else dont count or update the count result in B7.
You are going to need to tell us what your expected outcomes are.
Basically whenever I change E1 row then it should update accordingly in B Row as per matching criteria.
For Example:-
If I Change E1 to WEEK 3 then it should check A6 to A10 and then accordingly update B column.
Yes, I get that, but what are the expected results? So, show me what the table on the left should look like if WEEK 2 is selected in E1, and then how it should look if WEEK 3 is selected. I know it's obvious to you, but it isn't to me.
Lets say I have 5 columns with different Weeks = So result in B column should get update in respective match result of A column.
Refer attached excel
Sorry - I don't understand at all what you are trying to do. Let's hope somebody else will.
Thanks For your efforts ...have a good day
Not sure I understand but see if this does what you want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks