Adding column when number exist

[Richard Horn]

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

 

[Jacob Skaria]

=SUMIF('Q1'!K8:K34,">1")

If this post helps click Yes

 

[T. Valko]

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)

 

[Richard Horn]

Thanks, I guess I was just trying to make it to hard