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
|