Adding column when number exist
 

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

Adding column when number exist
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Richard Horn" wrote:

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

Adding column when number exist
 

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

Adding column when number exist
 

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

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Richard Horn" wrote:

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