Vlookup finding subtotals only
Hi,
you can get the subtotal for each account from a sheet with the information
without the subtotals with the formula as follow in sheet1 column B
=sumproduct(--(A1=sheet2!$A$1:$A$1000),sheet2!$B$1:$B$1000)
I assumed that the column to summarize is column B from sheet2
"deco" wrote:
I have the following:
Sheet 1 = Column A = account number (ex. 675000) = lookup_value
Sheet 2 = Column A-G subtotaled for Colunm A, by account = Table_array
Col_index # is for G (7)
My problem, sheet 1 column A is only the account #.
How can I have it find in sheet 2 the account subtotals?
Its something to do with my sheet 1 account number since it doesnt match
the table array €śaccount # total€ť on sheet 2 for the lookup.
Thanks
|