You'll have to better explain/describe you setup.

--
Biff
Microsoft Excel MVP


"Stacy C" wrote in message
...
Good afternoon,

Continuing with my spreadsheet (yay). I decided to modify it to SUM a row
based upon a value entered in another field. Here is the (general)
scenario.

I have a group of people, who are either Team 1 or Team 2. Since they are
setup alphabetically across the spreadsheet, I do not have the Teams
grouped
together.

In a separate cell next to each individual's name, I have a field (VC1 or
VC2, respectively).

I am not sure if I explained myself clearly, but any assistance would be
appreciated. Thank you.

I want to be able to SUM all of the VC1s and VC2s, example:

If D2 = VC1, then include B5 in the addition, if H2 = VC1, then include
F5,
etc.