I have a table with a calculated column. Column A will have numerical values. Column B has a drop-down list of yes or no. Column C will have dates. I need a formula that will take the product of Column A and the number two that (1) fall within a date range, and (2) "yes" from Column B. If "no" in Column B, and fall within a date range, the sum of Column A will occur.
I already have in place a formula that takes the product of Column A and two. I tried to incorporate the yes/no criterion, but fail each time. As an example the formula I have in place is:
SUMIFS(Tissue!K:K,Tissue!N:N,">="&DATE(2017,1,1),Tissue!N:N,"<="&DATE(2017,1,31),Tissue!A:A,"BBA")
This formula automatically sums the column within the specific date range. How would I modify it to fit the aforementioned criteria?
Bookmarks