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

Answerbag | Terms of Service | Privacy Policy