Is SUMIF correct?

M

mckielj

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

mckielj

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

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

mckielj

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