Show "error" in cells Q34 and Q42 if C3,Q2 is left blank

[anilpatni1234]

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" is

Please Login or Register  to view this content.

And 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 help me anyone. thank You.

I have attached the sample workbook

[davesexcel]

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 be

Please Login or Register  to view this content.

[anilpatni1234]

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

[Glenn Kennedy]

Please post a sheet WITHOUT protection.

[davesexcel]

Possibly,

Here is something if C3=""

Please Login or Register  to view this content.

[anilpatni1234]

Hey this is the sheet.
Sorry for the mismanagement

[anilpatni1234]

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?

[Glenn Kennedy]

Q34:
=if(and(c3<>"",q2<>"",p33=o33),sum(q11:q31),"error")

[Glenn Kennedy]

Q42:
=if(and(c3<>"",q2<>"",P33=O33),SUM(Q35,Q34)-SUM(Q38:Q40),"ERROR")

[anilpatni1234]

Hey Glenn . This worked for me. Thank you so much