ANSWERS: 2
-
Using the IF function should allow you to do what you want. Something like =IF(SUM(A1:A20)=100,SUM(A1:A20),"Criterion not met")
-
Based on your clarifications in the comments with Brian, you should check out the SUMPRODUCT() function. In its simplest form, given a simple example of numbers in column A:A, some text (or none) in column B:B, it could look like: This formula could be at, say, B101: =sumproduct(( A1:A100) * (B1:B100 = "Yes")) What this will do is add all of the values of "A1:A100" ONLY where the corresponding B:B value is "Yes", and ignore all other A:A values. You can combine this with an indefinite number of columns.
Copyright 2023, Wired Ivy, LLC

by 