Unable to add numbers from another sheet
I have a sheet that imports data from a database. In another sheet I want to
add the numbers in a column B if the string in column Is "ABC".
I have tried different functions such as
"=SUMPRODUCT(--(Sheet1!B7:B238="ABC")*Sheet2!D7:D238)" AND
"=SUMIF(Sheet1!B7:B238,"ABC",Sheet1!D7:D238)"
Nothing seems to work. Any suggestion will be a great help. I am on deadline
here.
Thanks.
|