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.
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.