Formula to look for number in a column and add cell in same row but different column

[Nelson3494]

I have a sheet for each month of the year and one of the columns are the dates and just single numbers (1 through 31 obviously) and next to the date column is a price column for our bids corresponding to when that job bid. I want a formula that can look at the date and determine if it was the first week (numbers 1 through 7) and if it matches add up the price corresponding to that job (same row different column). Right now i did that by IF($E$7<=7,$F$7,0)+IF($E$8<=7,$F$8,0)+IF($E$9<=7,$F$9,0)+.... (<=7 because 7 is the end of week 1) and so on but this is tedious and hard to adjust as sometimes there are 30+ jobs in a month. For the second week i have the same thing but instead of IF($E$7<=7,$F$7,0) it's IF($E$7<=14,$F$7,0)+IF($E$8<=14,$F$8,0)+...(<=14 because 14 is the end of week 2) and then at the end i just subtract the first cell so that it takes out anything that was in week 1. Can someone shorten this somehow?

[etaf]

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Nelson3494]

I have posted the workbook. What I'm trying to simplify is in the bottom left on WK1 total and Wk 2 total.

[etaf]

i dont understand the totals
number of jobs and volume of jobs

can you put some data into the example - so we can see how you plan to fill in
and also the results expected

you maybe able to use countifs or sumifs to do the calculation

for example the weeks are in E date bid - is that the week range you want to use

then Sumifs(

for week 1
=SUMIFS(F8:F27,E8:E27,"<="&7)
for week 2
=SUMIFS(F8:F27,E8:E27,">="&8,E8:E27,"<="&14)

[Nelson3494]

i dont understand the totals
number of jobs and volume of jobs

can you put some data into the example - so we can see how you plan to fill in
and also the results expected

you maybe able to use countifs or sumifs to do the calculation

for example the weeks are in E date bid - is that the week range you want to use

then Sumifs(

for week 1
=SUMIFS(F8:F27,E8:E27,"<="&7)
for week 2
=SUMIFS(F8:F27,E8:E27,">="&8,E8:E27,"<="&14)

Its fine i figured it out all the stuff about jobs i already had i just needed something for the weeks i ended up using =SUMIF(E7:E26, "<8",F7:F26). But anyways it is solved now thank you

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.