Forum Discussion
Adding function to Formula
I have used the following formular which works however I need to add a second criteria and this is where I have issues. I have selected the column than I have the two dates below so that I can change...
Hello, you can use sumifs or sumproduct.
Let's assume for your easy understanding as below.
List of People lived on Specific Lane=Sheet1! G3:G400
List of Lane=Sheet1!F3:F400.
House Lane = HL
You may change accordingly.
The formula using Sumifs is as below.
=SUMIFS(
Sheet1! G3:G400,
Sheet1! F3:F400, HL, Sheet1!C3:C400,">="&Sheet2!B125, Sheet1!C3:C400,"<="&Sheet2!B126, Sheet1!E3:E400,"Saturday")
The formula using Sumproduct is as below.
=SUMPRODUCT(
Sheet1! G3:G400*
(Sheet1! F3:F400=HL)*(Sheet1!C3:C400>=Sheet2!B125)*(Sheet1!C3:C400<=Sheet2!B126)*(Sheet1!E3:E400,"Saturday"))
Let's assume for your easy understanding as below.
List of People lived on Specific Lane=Sheet1! G3:G400
List of Lane=Sheet1!F3:F400.
House Lane = HL
You may change accordingly.
The formula using Sumifs is as below.
=SUMIFS(
Sheet1! G3:G400,
Sheet1! F3:F400, HL, Sheet1!C3:C400,">="&Sheet2!B125, Sheet1!C3:C400,"<="&Sheet2!B126, Sheet1!E3:E400,"Saturday")
The formula using Sumproduct is as below.
=SUMPRODUCT(
Sheet1! G3:G400*
(Sheet1! F3:F400=HL)*(Sheet1!C3:C400>=Sheet2!B125)*(Sheet1!C3:C400<=Sheet2!B126)*(Sheet1!E3:E400,"Saturday"))