Hello,
I am not a very sophisticated Exce user. I can do simple single
functions, but my skills are very limited to array formulas. Can you
help me? I got stuck.
Sheet1
Column A Column B Column C
Column D
CH #-812081T CH815 6180 125000
HK #-812081T CH815 - 75000
TH #-752075T AS755 - 11000
RP #-752075T AS755 213.72 89000
WW #-532053T WW535 4941.41 43,000

Sheet2
ColumnA Column B Column C
CH #-812081T CH815 125000
CH #-812081T CH05 6180
HK #-812081T CH815 75000
HK #-532053T 5785 4519.58
RP #-752075T AS755 89000
RP #-752075T 213.72
SN #-532053T WW535 30000
SN #-532053T 425.83
SN #-532053T WW535 13000
TH #-752075T AS755 11000

Column D - I used the sumif function. If I copy the formula down, it
duplicates the amount. I want to be able to copy the formulas down and
if it does not find a match, it should return a dash. I tried including
a match to the sumif function but I got an error in my formula. The
criteria is column A and column B of sheet1. I entered the return value
in this column.

Column C - I also used the sumif fuction. It should not include column
D and it should include "53" if it finds this text in column C. I
entered the return value in this column.

What is the logical order when writting array formulas? Can you explain
it? This will help me in the future?

Thank you