SUMIF needed for item based on date range

[excelteam777]

WS attached

I need a sumif formula based on date ranges entered.
Formula goes into J5
Start Date Range: F1 , Stop Date Range: F2

I need a sum from J11:J1110 only for the matching text in C5
based on the date range from E11:E1110 that fall between a date range entered into F1-F2.

[Ron Coderre]

Using your posted workbook...

I converted your data to an Excel Table named Table1. There's no need to use a fixed range with many blank rows. The Excel Table will automaticaly expand as new data rows are added. Also, formulas that reference Tables have Structured References which automatically self-document.

This regular formula, copied down through J6 returns the total price for the items and dates in the reference cells

Please Login or Register  to view this content.

The results are...(see attached file)

Please Login or Register  to view this content.

Is that something you can work with?

[excelteam777]

no, its not working. I would prefer to have the formula and use in reg excel sheet so i can adjust it as needed. Do you have that?

[Ron Coderre]

Well..."no, its not working" doesn't really describe the issue. I had no target values to match.

Attached is a workbook without the table and with adjusted formulas
J5:

Please Login or Register  to view this content.

IMHO...not as elegant as:

Please Login or Register  to view this content.

Is that something you can work with?