I have a excel file where I need "error" in cells Q34 and Q42 is cells C3 and Q2 is left blank.
Currenty the formulae which I have in cell "Q34" isAnd the formulae in "Q42" is
Please Login or Register to view this content.Currently if Count of Range "B11:B31" does not match count of "P11:P31" the it shows error in cells "Q34" and "Q42"Please Login or Register to view this content.
Please help me anyone. thank You.
I have attached the sample workbook
What is the question, your formula in O33 is not counting B11:B11
Your formula in O33 is "=COUNT($O$11:$O$31)" not column B.
Should it not beFormula:
Please Login or Register to view this content.
hey davesexcel,
thank you.
Yeah. Currently if count of "o11:o31" does not equal to count of "P11:P31" then it shows error in cells Q34 and Q42
So along with this , i wanted it to show error in cells Q34 and Q42 if cells C3 and Q2 is left blank.
Sorry for the trouble
Please post a sheet WITHOUT protection.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Possibly,
Here is something if C3=""
Please Login or Register to view this content.
Hey this is the sheet.
Sorry for the mismanagement
Hey daveexcel,
Can we also put cell Q2 in the formulae? So whenever C3 and Q2 is left blank then it shows error.
Also what forumlae do i put in Q42?
Q34:
=if(and(c3<>"",q2<>"",p33=o33),sum(q11:q31),"error")
Q42:
=if(and(c3<>"",q2<>"",P33=O33),SUM(Q35,Q34)-SUM(Q38:Q40),"ERROR")
Hey Glenn . This worked for me. Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks