Search and calculate formula
 

I am working on a project and trying to figure out a formula. What I want to
have happen is in the A column I have different project codes and in the H
column I have the cost of the task. I would like to have a formula that will
find a specific code in column A and then add the amounts in column H so I
would have a total sum.

Thanks!
--
Christina

Search and calculate formula
 

Hi Christina,

<and then add the amounts in column H

Add to what?

Did you look at VLOOKUP()?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Xina5280" wrote in message ...
|I am working on a project and trying to figure out a formula. What I want to
| have happen is in the A column I have different project codes and in the H
| column I have the cost of the task. I would like to have a formula that will
| find a specific code in column A and then add the amounts in column H so I
| would have a total sum.
|
| Thanks!
| --
| Christina

Search and calculate formula
 

For example:
Code Date Ticket Description Equiptment Total

105 1/2/2008 55 Check grade Labor $87.50
104 1/2/2008 307 Level stockpile site 972 $225.00
108 1/3/2008 56 Exc center hole Bobcat_MiniEx $85.50
104 12/20/2007303 Level stockpile site 972 $225.00

What I need to do is say for instance "how much in total was spent for code
104"?
I need a formula that will search code 104 in the CODE column and then add
together the total amount that was spent. Which would give an answer of $450



--
Christina


"Niek Otten" wrote:

Hi Christina,

<and then add the amounts in column H

Add to what?

Did you look at VLOOKUP()?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Xina5280" wrote in message ...
|I am working on a project and trying to figure out a formula. What I want to
| have happen is in the A column I have different project codes and in the H
| column I have the cost of the task. I would like to have a formula that will
| find a specific code in column A and then add the amounts in column H so I
| would have a total sum.
|
| Thanks!
| --
| Christina

Search and calculate formula
 

With the codes in A and the Totals in E:

=SUMIF(A1:A4,104,E1:E4)

Of course the 4 could be much higher (the row number)

You could also look at DataSubtotals to see all the details and all the totals in one report

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Xina5280" wrote in message ...
| For example:
| Code Date Ticket Description Equiptment Total
|
| 105 1/2/2008 55 Check grade Labor $87.50
| 104 1/2/2008 307 Level stockpile site 972 $225.00
| 108 1/3/2008 56 Exc center hole Bobcat_MiniEx $85.50
| 104 12/20/2007303 Level stockpile site 972 $225.00
|
| What I need to do is say for instance "how much in total was spent for code
| 104"?
| I need a formula that will search code 104 in the CODE column and then add
| together the total amount that was spent. Which would give an answer of $450
|
|
|
| --
| Christina
|
|
| "Niek Otten" wrote:
|
| Hi Christina,
|
| <and then add the amounts in column H
|
| Add to what?
|
| Did you look at VLOOKUP()?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Xina5280" wrote in message ...
| |I am working on a project and trying to figure out a formula. What I want to
| | have happen is in the A column I have different project codes and in the H
| | column I have the cost of the task. I would like to have a formula that will
| | find a specific code in column A and then add the amounts in column H so I
| | would have a total sum.
| |
| | Thanks!
| | --
| | Christina
|
|
|

Search and calculate formula
 

Perfect thank you!
--
Christina


"Niek Otten" wrote:

With the codes in A and the Totals in E:

=SUMIF(A1:A4,104,E1:E4)

Of course the 4 could be much higher (the row number)

You could also look at DataSubtotals to see all the details and all the totals in one report

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Xina5280" wrote in message ...
| For example:
| Code Date Ticket Description Equiptment Total
|
| 105 1/2/2008 55 Check grade Labor $87.50
| 104 1/2/2008 307 Level stockpile site 972 $225.00
| 108 1/3/2008 56 Exc center hole Bobcat_MiniEx $85.50
| 104 12/20/2007303 Level stockpile site 972 $225.00
|
| What I need to do is say for instance "how much in total was spent for code
| 104"?
| I need a formula that will search code 104 in the CODE column and then add
| together the total amount that was spent. Which would give an answer of $450
|
|
|
| --
| Christina
|
|
| "Niek Otten" wrote:
|
| Hi Christina,
|
| <and then add the amounts in column H
|
| Add to what?
|
| Did you look at VLOOKUP()?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Xina5280" wrote in message ...
| |I am working on a project and trying to figure out a formula. What I want to
| | have happen is in the A column I have different project codes and in the H
| | column I have the cost of the task. I would like to have a formula that will
| | find a specific code in column A and then add the amounts in column H so I
| | would have a total sum.
| |
| | Thanks!
| | --
| | Christina
|
|
|