sum column while excluding corresponding text values?

I want to sum a column of numbers in another workbook but exclude
numbers from my total that have certain words ("batch" and "state") in
a corresponding column. So using the table example below my formula
would return a sum of 303.

Table example:

Routing Events
Flood Plain Mapping 101
Mapping by Batch 150
Manual Determination 101
State Reconsideration 199
Individual Reconsideration 101

Make sense?

Based on some other formulas I saw in newsgroups here is a formula I
tried to use but it didn't work.

=SUM((Queue_User_Routing.csv!$E$2:$E$2000)*MATCH((Queue_User_Routing.csv!$C$2:$C$2000<>"Batch")*(Queue_User_Routing.csv!$C$2:$C$2000<>"State")))

Any help would be appreciated.

Thanks,
-Danny

.

Relevant Pages

  • Re: Adding sums only in certain colored cells
    ... If in another workbook like Personal.xls you must preface with the file name. ... Gord Dibben MS Excel MVP ... Function SumByColor(InRange As Range, WhatColorIndex As Integer, _ ... If looking to sum by BG color use FALSE as argument. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Adding sums only in certain colored cells
    ... If in another workbook like Personal.xls you must preface with the file name. ... Gord Dibben MS Excel MVP ... Function SumByColor(InRange As Range, WhatColorIndex As Integer, _ ... If looking to sum by BG color use FALSE as argument. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Adding sums only in certain colored cells
    ... Copy Chip's SumByColor Function to a general module in your workbook. ... If not familiar with VBA and macros, see David McRitchie's site for more on ... If looking to sum by font color use TRUE as argument. ... If manually colored you will need VBA to SUM them by color. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do you link shared spreadsheets and reference certain cells
    ... and select the approbiate range on the other workbook. ... Close the other workbook and test if SUM still works (and what path ... > I have tried moving the quotes, changing to dbl quotes, ... >> Frank Kabel ...
    (microsoft.public.excel.misc)
  • Re: Conditional Sum
    ... you wanted to sum B based on A and C ... Make sure the workbook is opened when you apply the formula than Excel ... to set up a conditional sum from one workbook to antoher. ... This is in work book 1 ...
    (microsoft.public.excel.misc)