if column has a specific value, sum the second cell two columns down

Gabimdr

New Member
Joined
Jun 6, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Hey,
I'm pretty new to excel, so maybe this is simple to do, but I need help with:
I have a default table I import the data from my team's activity by date, if we do the same thing on the two days later, I will add the same table a few rows down, just with the new data, my problem is, I need to sum those values by week and the dates we do things are different every week, so I don't have a fixed place where each date will be each week, because if there is no activity, there is no table for that date, so I might have a week with 2 tables and another with 4
So I have the same default table at the top of my spreadsheet but the date cell is the week's range and I need a formula that if the date in a column ( ex: column C) is between this range (the week range), it will sum the cell on the row bellow on the column D and so on, in a way my week table will have the sum values from the tables bellow, but only if the date matches. Here is a silly example of what my table is for visualisation:
Screen Shot 2021-06-06 at 17.05.58.png
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,144,339
Messages
5,723,800
Members
422,517
Latest member
VisioExcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top