Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 75
  • Last Modified:

join 2 Blankcells formulas together

is it possible [although I don't seem to be able to do it] to join 2 Blankcells formulas

i.e.

=COUNTBLANK('Fees( HK)'!I8:I16) gives me the correct answer 2

=COUNTBLANK('Fees( HK)'!I24:I25) gives me the correct answer 2

so I want to join these into one formula to get the answer 4

i.e.

=COUNTBLANK('Fees( HK)'!I8:I16) plus =COUNTBLANK('Fees( HK)'!I8:I16)

thanks
0
Jagwarman
Asked:
Jagwarman
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

have you tried to add the two results? As in

=COUNTBLANK('Fees( HK)'!I8:I16)+COUNTBLANK('Fees( HK)'!I24:I25)

If that does not help, please post a sample file.

cheers, teylyn
0
 
Saqib Husain, SyedEngineerCommented:
=COUNTBLANK('Fees( HK)'!I8:I16) plus+COUNTBLANK('Fees( HK)'!I8:I16)
0
 
JagwarmanAuthor Commented:
Hmm! easy when you know how :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now