Is SUMIF correct?

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".

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?

=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?

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".


"daddylonglegs" wrote:

>
> =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?
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=557429
>
>