Formula help

[KellieMeehan]

Hi,

I have the following data and currently using, =exact to check columns E & F, but f is a sum of J,K & L, I would like a formula that can do all this with out having the additional column F adding everything in J,K & L, and also can an IFERORR be used for blank columns, so that when data is inputted in the columns that in the "Matched" column it populates the TRUE/FALSE?

Thank you for reading

 

[FormR]

Hi, if you are not willing to try the suggestion I have made (or make a comment about why it doesn't work for you) then I'm afraid I won't be able to help any more.

I'll respectfully bow out of this thread now.

 

[KellieMeehan]

Hi, if you are not willing to try the suggestion I have made (or make a comment about why it doesn't work for you) then I'm afraid I won't be able to help any more.

I'll respectfully bow out of this thread now.

Sorry new to this, wasn't sure what you were suggesting as I was just looking for a formula

 

[FormR]

I was just looking for a formula

Here it is again:

=E2=SUM(J2:L2)

It doesn't address this:

but where there is no data that column G is blank until data is inputted

As waiting for an answer on this:

Which column(s) need to be populated before the calculation is attempted? Just column E?

 

[KellieMeehan]

Here it is again:

=E2=SUM(J2:L2)

It doesn't address this:


As waiting for an answer on this:

I have added the sum to column E, I would really like to get rid of this and for a formula to look at I2,J2,K2 if matched with D2, for this to say MATCHED in Column F and if it doesn't then UNMATCHED. is this possible? and then instead of having to pull the formula down in ColumnF for eadh row, that like an IFERORR formula that say F6 below stays blank until data is entered, is this possible?

 

[FormR]

F6 below stays blank until data is entered

Until data is entered where? Just column D?

I would really like to get rid of this and for a formula to look at I2,J2,K2 if matched with D2, for this to say MATCHED in Column F and if it doesn't then UNMATCHED

=IF(D2=SUM(I2:K2),"MATCHED","UNMATCHED")

 

[KellieMeehan]

Until data is entered where? Just column D?



=IF(D2=SUM(I2:K2),"MATCHED","UNMATCHED")

Data is entered in I,J, & K

 

[FormR]

Then you can try this, which will return a result if any of those 3 cells contains a number.

=IF(COUNT(I2:K2),IF(D2=SUM(I2:K2),"MATCHED","UNMATCHED"),"")

 

[KellieMeehan]

Then you can try this, which will return a result if any of those 3 cells contains a number.

=IF(COUNT(I2:K2),IF(D2=SUM(I2:K2),"MATCHED","UNMATCHED"),"")

I could kiss you !, you are amazing thank you for helping me this morning

 

[KellieMeehan]

I could kiss you !, you are amazing thank you for helping me this morning