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

Yup, Sumif would be perfect


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=557429

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?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557429

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