CODEWITHSUNDEEP
excel
user2704251
user2704251

Reputation: 1

Trying to use the value in one cell to populate a formula in another cell

Does anyone know how to use the value of one cell to fill in a formula?

i.e. My cell y5 and cell AA5 contain the numerical date value, and I want to place that value in my formula listed below:

=SUMIF(I:I,">=Y5",J:J)-SUMIF(I:I,">=aa5",J:J)

This is the completed formula if I type it in:

=SUMIF(I:I,">=41671",J:J)-SUMIF(I:I,">41698",J:J)

Upvotes: 0

Views: 194

Answers (2)

Johnny Bones
Johnny Bones

Reputation: 8402

Did you try it, and did it give you a specific error? I know for a fact it can be done, and I think your formula is probably close. In fact, I think your problem is just the placement of your quotes. Try something like this:

=SUMIF(I:I,">="&Y5,J:J)-SUMIF(I:I,">="&AA5,J:J)

Upvotes: 0

Jerry
Jerry

Reputation: 71538

Hmm, not sure why you put them between quotes, because, well, quotes makes it a literal string and no substitution will be performed in the formula. Try this instead:

=SUMIF(I:I,">="&Y5,J:J)-SUMIF(I:I,">="&AA5,J:J)

The & is concatenating the operator to the substituted value.

Upvotes: 2

Related Questions