View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
swestberry swestberry is offline
external usenet poster
 
Posts: 1
Default Sum a column if two criteria are met

I need a formula that sums column C for each "Loc" by "Item"?

A B C
LOC Item WA Txn Value
1241 R3331 595.20
1241 R3334 595.20
1241 R3334 1,488.00
1242 R1400 908.46
1242 R1400 908.46
1242 R3334 1,488.00
1242 R3334 1,190.40
1243 R1400 908.46
1243 R3334 297.60


--
swestberry