COUNTIF & SUMIF with date range help

**botchot88** · 01-24-2016, 09:56 AM

Hi All

I am currently using =COUNTIF($D$8:$D$24,C30) to tell me how many Mondays are listed across 17 consecutive days. i.e I need to know how many mondays, tuesday wed there are in those 17 days.

I am also using: =SUMIF($D$8:$D$24,C30,$E$8:$E$24) to count the total $ (e column) for each day across the 17 days.

These formulas are great and doing exactly what I want them to be doing.

So far we are using column D: Day, Column E: $ amount for corresponding day in col D and also a reference in column C (Monday or Tuesday, Wednesday etc)

Here is my dilemma:

Not in my formula's above, is the date range in column c i.e =C8:C24 . This colun lists the date for each day on a seperate row i.e 01/01/2015 (C8) 02/01/2015 (C9). They correspond with the days listed in column D and the $ in column E.

I need to add in somehow conditional range so that I can calculate the countif and sumif, but on the basis of two dates (beginning and ending).

Can someone please help?

I have attached the excel file for you to see.

I have a preference not to use VBA or arrays if possible.

Thanks in advance!