S
sadat
Hello,
My problem is that I have data in four columns. First column has the data
which is mixed of text and numbers (Eg. KAM-1000), second column has date
(Eg. 23-May-2007), third column has text that is different types of product
name, last column is the price of the products. I want to sum up the last
column if all the three columns matches three different criteria. I am giving
an example of the data below:
ID Date Product Name Price
KAM-1000 23-May-07 Apple 400
KAM-1001 24-MAY-07 Orange 100
KAM-2000 25-MAY-07 Grape 200
KAM-1000 23-May-07 Apple 300
Now I want the function to sum up the row 1 and 2 and give a result of 700.
I used this formula but it resulted 0:
=SUMPRODUCT($A$221:$A$224="KAM-1736",$G$221:$G$224="Business Solutions -
Dhaka",--(TEXT($E$221:$E$224,"yyyymmmdd")="2007May23"),$M$221:$M$224)
What should I do? Is there any other function which will give me the
accurate result?
Thanking you in advance
My problem is that I have data in four columns. First column has the data
which is mixed of text and numbers (Eg. KAM-1000), second column has date
(Eg. 23-May-2007), third column has text that is different types of product
name, last column is the price of the products. I want to sum up the last
column if all the three columns matches three different criteria. I am giving
an example of the data below:
ID Date Product Name Price
KAM-1000 23-May-07 Apple 400
KAM-1001 24-MAY-07 Orange 100
KAM-2000 25-MAY-07 Grape 200
KAM-1000 23-May-07 Apple 300
Now I want the function to sum up the row 1 and 2 and give a result of 700.
I used this formula but it resulted 0:
=SUMPRODUCT($A$221:$A$224="KAM-1736",$G$221:$G$224="Business Solutions -
Dhaka",--(TEXT($E$221:$E$224,"yyyymmmdd")="2007May23"),$M$221:$M$224)
What should I do? Is there any other function which will give me the
accurate result?
Thanking you in advance