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

[PA_VA13]

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.

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.

 

[kvsrinivasamurthy]

Does date in $AL14 exactly matches with the dates in "Date" range. AL14 is text or change in AL14 year will cause problem.

 

[PA_VA13]

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.

 

[kvsrinivasamurthy]

Is it possible to post a sample file replacing sensitive data by dummy data.

 

[PA_VA13]

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.

SP tab where data is pulled from

 

[kvsrinivasamurthy]

Is it possible to upload a sample file in some site and give link here.