Sum of a column based on name and date entered on another tab
I am working with two tabs. Billing and Totals.
On the Billing tab – Column B is the date, Column G is the name (Sue), and the number to be summed is in column F.
On the Totals tab, B3 is 1/1/2024, C3 is 2/1/2024, and so on, ending at M3 12/1/2024.
“Sue” appears in the static position of A4 on the totals tab.
I need a formula on the Totals tab that will look at the Billing tab and give me the sum of the numbers entered into column F, IF the name in G is “Sue”, AND the date in B is the specified month. The formula will be copied over for each month and for each name. (I can make the changes to point at the right month and name once I have the actual formula to work with).
Hopefully this makes sense to someone. It barely makes sense to me.
I am working with two tabs. Billing and Totals.On the Billing tab – Column B is the date, Column G is the name (Sue), and the number to be summed is in column F.On the Totals tab, B3 is 1/1/2024, C3 is 2/1/2024, and so on, ending at M3 12/1/2024.”Sue” appears in the static position of A4 on the totals tab.I need a formula on the Totals tab that will look at the Billing tab and give me the sum of the numbers entered into column F, IF the name in G is “Sue”, AND the date in B is the specified month. The formula will be copied over for each month and for each name. (I can make the changes to point at the right month and name once I have the actual formula to work with).Hopefully this makes sense to someone. It barely makes sense to me. Read More
