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:
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? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||