If by "blank" you mean truly *empty* cells, *not* cells that equate to zero
length strings (""), and the "1" is a numerical 1, *not* a text "1", you can
try this *array* formula:

=SUM(--ISBLANK(A1:A10),COUNTIF(A1:A10,1))

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Thrlckr" wrote in message
...
Hello,

I am trying to get Excel to count up blank (or non-shaded) cells, as well
as
cells that contain a "1" in it. Can someone please suggest a formula to
do
that? I really need it & an excel "guru" told me it could be done, but he
didn't remember how. Any help would be greatly appreciated.

Thank you!