Sum on multiple columns

[Guest]

I am using a workbook which contains 3 sheets representing a country(Mexico,
Brazil, India) .In these sheets there are 4 columns which contain the
following:

(Customer Name) (Customer Account) (Dollar Amt) (Product Id)

There are multiple Product Id that can be charged to a customer account and
i am using a filter by product id to get sum amount of customers from each
country.How does one get a sum for all countrys combined?

Thanks

 

[Domenic]

To sum the dollar amount for a specified 'Product ID' for all three
sheets, try...

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Mexico","Brazil","India"}&"'!D2100"),G
2,INDIRECT("'"&{"Mexico","Brazil","India"}&"'!C2:C100")))

It assumes that the sheet names are Mexico, Brazil, and India, and that
on each sheet A2100 contains the data. Also, G2 contains the 'Product
ID' of interest. Adjust the range accordingly.

Hope this helps!

 

[Guest]

Thanks,
Would this work if i did not do a filter and the various Product ID were
displayed?

 

[Domenic]

Simply enter the 'Product ID' of interest in a cell, such as G2 in my
example, adjust the ranges (D2100 and C2:C100) accordingly, and the
formula will return the results for all sheets, regardless of whether
the data is filtered.

 

[Guest]

Thanks for the help Domenic. I tried keying manually and copy paste of you
formula but i get an error of missing parenthesis in the formula.Is there
somehthing else i could have done wrong?

 

[Domenic]

Thanks for the help Domenic. I tried keying manually and copy paste of you
formula but i get an error of missing parenthesis in the formula.Is there
somehthing else i could have done wrong?

Can you post the exact formula you're using?

 

[Guest]

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Mexico","Brazil","India"}&"'!D6100"),H6:H100
,INDIRECT("'"&{"Mexico","Brazil","India"}&"'!C2:C100")))
I have copied your formula but i am probably doing this incorrectly: where the
usd dollar amount exists in column "D" CUSTOMER NAME IS column "E" CUSTOMER
ACCT COLUMN "F" AND THE PRODUCTID is column "H". I used H6:H100 since this is
the range in which the productID exists.

 

[Domenic]

In that case, try...

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Mexico","Brazil","India"}&"'!H2:H100"),G
2,INDIRECT("'"&{"Mexico","Brazil","India"}&"'!D2100")))

....where G2 contains the Product ID of interest. In other words, enter
in G2 the Product ID for which you would like an overall sum, and the
formula will sum Column D on each sheet where the corresponding cell in
Column H contains the Product ID specified in G2.