Adding Data Conditionally 2

[quig699]

Hi,

I am looking for a way to take spread sheet and pull totals in a cell if certain conditions are met from the data and I am hitting the wall. My spreadsheet will have the columns of Agent Name, Issue Code and Amount. Assuming the issue codes are letters and I only want a sum of the 'Amount' for X and Y for the specific 'Agent Name', what method can I use?

Any help you can provide is greatly appreciated.

Thank You so much!!

Thanks,

Amy

 

[SkipVought]

hi,

An example would sure be in order to help direct the answer, as it depends on the TYPE of data you want to conditionlly display.

Could you post a TABLE as an example and the specific condition and result you expect?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

I'd say offhand that SUMIFS() might work, if I understand your requirement.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[byundt]

Assuming that you follow Skip's advice, SUMIFS will give you the sum of values for either Issue Code "X" or "Y". But you can use a SUM(SUMIFS(...)) formula to get the sum of both conditions:

=SUM(SUMIFS(Table1[Value],Table1[Agent Name],"Bob",Table1[Issue Code],{"X","Y"}))

In Excel 2003 or earlier, you can use SUMPRODUCT:

=SUMPRODUCT(C$2:C$350,(A$2:A$350="Bob")*(ISNUMBER(FIND(B$2:B$350,"XY"))))

The reference to row 350 is arbitrary and may extend beyond your data.

Sample file in my SkyDrive

Brad

 

[quig699]

Thank you all so much!!! Your advice pointed me in the right direction. It is much appreciated!!!!

Thanks,

Amy