It's not real clear where the data is that you want summed.

If the cells are either empty/blank or contain numbers can't you just use a
SUM formula?

=SUM('Q1'!K8:K34)

--
Biff
Microsoft Excel MVP


"Richard Horn" wrote in message
...
I have a project workbook and I am working on a summary page.

From the Q1 worksheet, column K, we have listed cost savings. Some
projects
have a cost savings and others are blank -- no cost savings.

I am using this formula to add the total cost savings of any projects in
K8:K34.

=SUMPRODUCT(('Q1'!K8:K34"1")*('Q1'!K8:K34<""))

This formula returns 2, which is correct, there are 2 projects with cost
savings. But what I really wanted to know was what the toal cost savings
was.

In others words, $680,813 for project 1 and $508,680 for project 2 would
be
a total cost saving for Q1 of $1,189,493. That is number I wanted
returned.

Thanks