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

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

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Mexico","Brazil", "India"}&"'!D2:D100"),G
2,INDIRECT("'"&{"Mexico","Brazil","India"}&"'!C2:C 100")))

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

Hope this helps!

In article ,
jk wrote:

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

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

"Domenic" wrote:

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

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Mexico","Brazil", "India"}&"'!D2:D100"),G
2,INDIRECT("'"&{"Mexico","Brazil","India"}&"'!C2:C 100")))

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

Hope this helps!

In article ,
jk wrote:

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

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

In article ,
jk wrote:

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

"Domenic" wrote:

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

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Mexico","Brazil", "India"}&"'!D2:D100"),G
2,INDIRECT("'"&{"Mexico","Brazil","India"}&"'!C2:C 100")))

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

Hope this helps!

In article ,
jk wrote:

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

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" wrote:

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

In article ,
jk wrote:

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

"Domenic" wrote:

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

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Mexico","Brazil", "India"}&"'!D2:D100"),G
2,INDIRECT("'"&{"Mexico","Brazil","India"}&"'!C2:C 100")))

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

Hope this helps!

In article ,
jk wrote:

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

In article ,
jk wrote:

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?