View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Isolate and total cell values based on conditions

Try this"

=Sumif(A5:A356,"WFD",B5:B356)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jkl" wrote in message
...
Information in column A. If that info equals a particular value, such as
"WFD", then I want the dollar figure in column B to be counted. I want

this
to happen for rows 5 through 356 so as to get a subtotal for that range

that
only includes dollar figures that correspond to the particular value (i.e.
WFD).

TIA