HELP! SUMIF - 2 conditions not working!

[AndstarFantastica]

I'm trying to do a sumif with two criteria. I have used this before but it is not working.

Column A is filled with dates a text was sent to a user.
Column B is the Text title of the campaign the text was involved with.
Column C is a quantity column with the number '1' in every cell.


Cell D1 is where I write in the Campaign Title

Cell's D2 and D3 are the Date ranges I want to retrieve the data from.

Cell D4 is where I need the result to output

Essentially If Cell D1 states 'Campaign 0001'. I want it to look up column B and retrieve the sum of the quantity in Column C BUT ONLY if the sum is within the date range between D2 and D3 as found in Column A.

Any ideas?

[stanleydgromjr]

AndstarFantastica,

Welcome to the Excel Forum.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

Please supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Scroll down and see "Manage Attachments".