SUMIFS OR SUMPRODUCT

[sureshsonti]

Hi,
I have my raw data in data sheet and what to extract data based on location, price, month and year.

I have 2 sections in the output tab. In the 1st section I have plants with qty and amounts where I used sumifs functions.

In section 2 I want to extract data from location other than the plants. I only have 4 plants and had no problem extracting the data.

So in Section 2 I want Other Locations Qty multiplied by the Price by year, month.

Thanks for all your help

 

[bosco_yip]

Perhaps.........

1] B14, copied across :

=SUMIFS(qty,date,">="&B$4&$A$2,date,"<="&EOMONTH(B$4&$A$2,0),location,"<>plant*")

2] B15, copied across :

=SUMIFS(amounts,date,">="&B$4&$A$2,date,"<="&EOMONTH(B$4&$A$2,0),location,"<>plant*")

Regards
Bosco

 

[sureshsonti]

Thanks Bosco. What does the Asterisk mean in the formula. Is it select all with the word PLANT.

Thanks

 

[bosco_yip]

Thanks Bosco. What does the Asterisk mean in the formula. Is it select all with the word PLANT.

Thanks

* (asterisk) is a wildcard character, try to press F1 (help file) and search "wildcard" for further detailing.

Regards
Bosco

 

[sureshsonti]

Thanks Bosco. Will look it up. Thanks again