Is SUMIF correct?

[Guest]

I am running a Web Querry and importing a table into excel. I need to
deterime the sum of of D:1 Based on A:2.

A:1 Customer B:1 ETA Date C:1 Labor$ D:1 Hours
A:2 Request B:2 Duration C:2 Total Cost D:2 Material $

The table that is being imported has 271 groups of information as shown
above that I would like to sum based on "Request".

 

[Bearacade]

Yup, Sumif would be perfec

 

[Guest]

I am using =SUMIF(A:A,"Request",C:C) but it only gives me the sum of the
infomation in the same row as the Criteria that I'm using. I need to get the
sum of the information in another row other then the row the Criteria is in.
How would I do this?

 

[daddylonglegs]

=SUMIF(A:A,"Request",C:C)

should give you a sum of all values in column C where the same row has
the text "Request" (and only that) in column A. Is that your
requirement?

 

[Guest]

I have been able to sum the information in column C on the same row as
"Request".
I also want to sum the information in column C but in a row based on
"Request".