Copy value in a cell to another cell based on value in a third cell, HAS A Bug.

[SteveZed]

Hi All,

I have marked as SOLVED “Copy value in a cell to another cell based on value in a third cell”, I have decided to start a new thread with basically the same title.

Upon testing it further I think I have come up against a “bug”.
It works fine until I do the following (in the uploaded workbook).


Row 4 to row 6 have been filled with Payments and categories to show it works fine.

Now in row 7 enter as follows: A7=10, B7=1 , now enter C7=10, the result is a 1 in T7 ( ie category 10, is not expected ).

Notice that whenever payment =10, category =1,2, 3 etc, payment =10, the category value is added to the 10th column T.

I Hope someone can come up with a solution to this “bug”.

Cheers,
Steve

[JohnTopley]

Remove by JT

See next post

[JohnTopley]

Try this

=SUMPRODUCT(($A4:$G4)*($A$3:$G$3="Payment $")*($B4:$H4=K$3)*($B$3:$H$3="Category"))

and remove extra character at the end of each "Category" headings

I should have used this in the first place: my apologies

[SteveZed]

Hi John,
That does the trick. Thanks again for your invaluable help.
I am getting to understand the SUMPRODUCT function a lot better.
Cheers,
Steve