COUNTA and Sum SOLVED

[budvegas]

Hi All

Sorry if this has been asked before.

I have using the following Formula:
=COUNTA(A3:A7,A10:A14,A17:A21,A24:A28,A31:A35)

Basically is counts how many week days there are in a particular month.

Now I have a cell (B47) that counts how many Bank Holidays are in that month.

I am having trouble using the formula then minus B47. I must be missing something really simple.

Any help would be awesome.

Many Thank

bud
\m/ :D \m/

[Richard Buttrey]

Hi,

Presumably

Please Login or Register  to view this content.

.

And if this isn't giving you the right result are you sure that the two COUNTA() formuale have the number you expect?

Rgds

[teylyn]

as in

=COUNTA(A3:A7,A10:A14,A17:A21,A24:A28,A31:A35)-B47

??

[budvegas]

Hi Guys

Thanks for that. I am sure I was doing that but just would get the correct answer. I must have been doing something wrong.

Thanks as always

bud \m/ :D \m/