Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Isolate and total cell values based on conditions
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Isolate and total cell values based on conditions
Presuming you meant to sum col B's values (not count)
Assuming you have listed in C2 down, eg: WFD, XXX etc Put in D2: =SUMIF(A:A,C2,B:B) Copy D2 down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jkl" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grand total based on conditions within an array | Excel Discussion (Misc queries) | |||
Total or Count based on multiple conditions | Excel Discussion (Misc queries) | |||
Cell values based upon multiple conditions | New Users to Excel | |||
Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions |