Hi I'm trying to use the sumif function but I want to sum everything in a
range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
sum everything that is not equal to apple should return 20. Thank you
Hi I'm trying to use the sumif function but I want to sum everything in a
range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
sum everything that is not equal to apple should return 20. Thank you
=SUMIF(A:A,"<>apples",B:B)
Vaya con Dios,
Chuck, CABGx3
"Ed" <[email protected]> wrote in message
news:[email protected]...
> Hi I'm trying to use the sumif function but I want to sum everything in a
> range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
> sum everything that is not equal to apple should return 20. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks