Drop Down Box Formula

[Petefav]

Hi All

Just wondering if anyone can help me construct a formula for a drop down box. I would like when the name TMP is selected from the drop down box (dropdownbox is in b2), a formula is executed that looks up any trades in column A from Jan/01/2012 to Feb/01/2012 with the e-mail format in column B [different name per employee here]@tmp.com to sum the volumes in column C of these matched cells to then display the answer in the sheet where the drop down box is located.

Basically when TMP is selected from the drop down box i want the answer in the next cell to tell me how much trading they did in the month of january.

I hope this makes sense.

Many thanks in advance.

Cheers

[dilipandey]

Hi Petefav,

Please post a sample workbook to support your query. thanks.


Regards,
DILIPandey
<click on below * if this helps>

[Petefav]

Hi All

Just to be clear I have attached a test excel spreadsheet.

Basically the formula I am looking for is in sheet ‘Drop Down Box’ cell D1. I would like the formula to perform actions along the line
of if C1 = TMP then search ‘Data’ A:A equal or greater than Jan/01/2013 and less than Feb/01/2013 and search B:B for e-mail address
format [any name]@tmp.com if matched sum volumes in C:C and populated answer in sheet ‘Drop Down Box’ D1

I hope this makes sense. Again many thanks in advance for your help.

Cheers

[FDibbins]

Try this....
=SUMIFS(Data!C:C,Data!A:A,">="&DATE(2013,1,1),Data!A:A,"<"&DATE(2013,2,1),Data!B:B,"*@"&$C$1&"*")