Melinda
02-09-2009, 09:20 PM
I have a spreadsheet that
(1) I need to sum all in column L that matches B43(5033110000) in Column C in the SAP worksheet(Hidden). Total is $3,511.81
(2) I need to pull all the document #'s(3000012230, 3000015769, 3000016096, 3000017954 and 3200000712) that match B43 in Column C in the SAP worksheet. If these each one of these documents have account number in column C in the SAP worksheet that begins with a "2" then pull the negative $ amount (-$3,511.81) in Column L associated with the row that matches B43 in Column C.
(3) (1) - (2) = C43
For the last two days I have tried using sumif, if, index, match and sumproduct but cannot seem to get it to work right.
Can someone please come to the rescue?
Melinda
(1) I need to sum all in column L that matches B43(5033110000) in Column C in the SAP worksheet(Hidden). Total is $3,511.81
(2) I need to pull all the document #'s(3000012230, 3000015769, 3000016096, 3000017954 and 3200000712) that match B43 in Column C in the SAP worksheet. If these each one of these documents have account number in column C in the SAP worksheet that begins with a "2" then pull the negative $ amount (-$3,511.81) in Column L associated with the row that matches B43 in Column C.
(3) (1) - (2) = C43
For the last two days I have tried using sumif, if, index, match and sumproduct but cannot seem to get it to work right.
Can someone please come to the rescue?
Melinda