Forum Discussion
Solved
IF & AND formula scenario with multiple criteria
Good Afternoon Everyone, I have a spreadsheet that contains 4 lists that I am trying to pull information from 3of them in to the main list based on multiple criteria. I am having trouble with com...
In C2:
=SUMIFS($I$2:$I$4,$F$2:$F$4,A2,$G$2:$G$4,"<="&B2,$H$2:$H$4,">="&B2)
Adjust the ranges for your actual setup, then fill down.
In C2:
=SUMIFS($I$2:$I$4,$F$2:$F$4,A2,$G$2:$G$4,"<="&B2,$H$2:$H$4,">="&B2)
Adjust the ranges for your actual setup, then fill down.
