Forum Discussion
nested IF formula returning #N/A error
I am attempting to have a formula do the following: If column L is greater than or equal to AL21 and if column L is less than AM21 and if column M is equal to "Y" then sum all of the blanks in column...
Hi,
Problem is you only specified conditions only (on which basis you want to sum), you forget to mention which value you have to sum. And IF('CAPA Tracking'!M:M="Y" will not work here.
Clarify the following. I will solve your question.
Note: In this case, use SUMIFS formula.
=SUMIFS('specify the range you want to sum',L:L,">="&AL21,L:L,"<"&AM21,M:M,"Y",O:O,"")
1. Which column you want to sum.
2. In which columns you have date values.