View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mckielj
 
Posts: n/a
Default Is SUMIF correct?

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