A
Alexander
I have a table with the following logical structure:
Name Number of apples Number of oranges Total fruits
Mike 3 2
5
John 4 5
9
Nick 2 6
8
Peter 3 5
8
How can I calculate how many apples (or oranges, or fruits in total) were
eaten by Mike and John together (i. e. to get sum total only for them) , but
ignore Nick and Peter? Or how can I exclude Peter from these calculations?
Your help is very much appreciated!
Name Number of apples Number of oranges Total fruits
Mike 3 2
5
John 4 5
9
Nick 2 6
8
Peter 3 5
8
How can I calculate how many apples (or oranges, or fruits in total) were
eaten by Mike and John together (i. e. to get sum total only for them) , but
ignore Nick and Peter? Or how can I exclude Peter from these calculations?
Your help is very much appreciated!