Matching Multiple Conditions from another Sheet within the same workbook

[brodhav]

Hello everyone, I want to run 4 different conditions on the data present in the source sheet and if all those conditions are met only then I want the function to return 1 in the B2 cell in "Main Sheet". (I've attached the screenshot as well as the sample workbook) MAIN SHEET: Sample Sheet.xlsx A B C D E F 1 Inventory 2 W L N TOTAL 3 JANUARY 1 1 4 FEBRUARY 0 5 MARCH 0 6 APRIL 0 7 MAY 0 8 JUNE 0 9 JULY 0 10 AUGUST 0 11 SEPTMEBER 0 12 OCTOBER 0 13 NOVEMBER 0 14 DECEMBER 0 Main Sheet Cell Formulas Range Formula B3 B3 =IF(AND('Source Sheet'!A2:A12="JANUARY",'Source Sheet'!C2:C12="T1",'Source Sheet'!D2:D12="Inventory",'Source Sheet'!E2:E12="W"),1,0) E3:E14 E3 =SUM(B3:D3) SOURCE SHEET: Sample Sheet.xlsx A B C D E F 1 Month Date Type Session Result 2 JANUARY 01/01/2022 T1 Inventory W 3 JANUARY 02/01/2022 T1 Inventory W 4 5 6 7 8 9 10 11 12 13 14 15 Source Sheet But as you can see, it only returns one 1 whereas it should have returned 2 since I want this value to keep adding with every record in "Source Sheet" that meets the said criteria. Can anyone help regarding this as to what I'm doing wrong here?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=COUNTIFS('Source Sheet'!A2:A12,"JANUARY",'Source Sheet'!C2:C12,"T1",'Source Sheet'!D2:D12,"Inventory",'Source Sheet'!E2:E12,"W")

 

[brodhav]

Hi & welcome to MrExcel.
How about

=COUNTIFS('Source Sheet'!A2:A12,"JANUARY",'Source Sheet'!C2:C12,"T1",'Source Sheet'!D2:D12,"Inventory",'Source Sheet'!E2:E12,"W")

Hey there,

Now I see where I messed up. Your formula worked like a charm. Thanks a ton, man! Appreciate it

 

[Fluff]

You're welcome & thanks for the feedback.