SUMIF formula to pull data from one tab to another with a column date range, type, and totals

PA_VA13

New Member
Joined
Jul 2, 2020
Messages
34
Office Version
  1. 2010
Platform
  1. Windows
Good moring,

I need help with a SUMIF formula to pull specific data types per date (listed in the AL column) from a specific tab (SP) to another tab (TALLIES). The formula will be in the TALLIES tab.
The issue is I don't know where in the formula to put the SP! part. The formula works fine in the SP tab where all the data is entered.

=SUMIFS(slides,date,$AL14,type,"R")+SUMIFS(slides,date,$AL14,type,"BM")+SUMIFS(slides,date,$AL14,type,"PB")+SUMIFS(slides,date,$AL14,type,"Ta")

AL Column has the dates that all of the formulas use.
1739454169719.png


Column C is the "date" part of the formula.
Column E is the "slide" part of the formula.
Column F is the "type" part of the formula.
1739454212665.png
 
Does date in $AL14 exactly matches with the dates in "Date" range. AL14 is text or change in AL14 year will cause problem.
the date in AL column are the same format as those in the date range of column C. I used the date in the AL column for the formula because these dates are consistent to the calendar year where as the dates in the C column are specific to the case #. There are often 50+ cases assigned to a date, but not always in the same grouping. Example cases 214-217 & 221-223 could have a date of 1/14/2025 while 218-220 could have a date of 1/19/2025.

Does that help? I would post the excel sheets but my company PC blocks me from doing so. I can only upload pictures.
 
Upvote 0
I wish I could. Our systems block the XL2BB. Best I can do is give a full screen of the mock up without sensitive data. I can try to see if I can send it from my phone.

TALLIES tab. Formula would start in cell C7 and it is just for the overall total # of R, BM, Ta, PB types to be divided by the # of Dr.s onsite (cell D) who are looking at the cases. The rest of the TALLIES tab pulls specific data from all 10 tabs for that Dr.
1739463843150.png


SP tab where data is pulled from
1739463994077.png
1739464062479.png
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,924
Members
453,767
Latest member
922aloose

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
Back
Top