W
Will
Dear All,
Kindly assist me with a table that i needed to count a sum with citeria
example:
John's: Day1 Day2 Total
Apples 50 100 150
Oranges 80 150 230
Papaya 100 50 150
Mark's
Oranges 150 50 200
Apples 100 50 150
Papaya 80 80 160
So on.........................
total Apples: 300
total Oranges: 430
total Papaya: 310
As there are hundreds of Names, i wonder whether there are a functions that
that "apples" as ref and count the total sum of it.
Kindly assist me with a table that i needed to count a sum with citeria
example:
John's: Day1 Day2 Total
Apples 50 100 150
Oranges 80 150 230
Papaya 100 50 150
Mark's
Oranges 150 50 200
Apples 100 50 150
Papaya 80 80 160
So on.........................
total Apples: 300
total Oranges: 430
total Papaya: 310
As there are hundreds of Names, i wonder whether there are a functions that
that "apples" as ref and count the total sum of it.