Let me follow up...

The problem in using SUMPRODUCT is that if you want a complete report for
all Towns, then you have to know what all the unique Towns are in advance.
If you have a large file, how do you propose to do that?

Let's say you have 25 different towns in your file, then you need 25
separate formulas if you want a complete report.

The much simpler method is to use a Pivot Table. You don't need to know
anything about your detail data, you only need to create the pivot table
with "Town" as the row variable, and "Description" as the column variable,
and "Volume" as the table contents. Then all combinations of Town and
Description will be created for you in a nice table (it's all drag and
drop). Ignore data you don't want.

Or, you can also use the row variable, Town, as a filter item for the pivot
table, if you only want to display one town at a time...

Much more powerful tool than trying to create a bunch of SUMPRODUCT
formulas...


"vijaydsk1970" wrote in message
...
I have a big excel sheet with different colums headings.
at the bottom i wanted a conditional sum basing on 3 columns
May be a example of my question be like as follows

column a column b column c
(town) (description) (volume)

vijayawada sales 23
guntur credit sales 27
vijayawada sales 30
guntur credit sales 40
nellore sales 55
vijayawada credit sales 25

computer has to sumup the corresponding values of sales and credit sales
separately for vijayawada, guntur, nellore

thanks in advance