Thread
:
SUMIF of adjacent variable cells
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
SUMIF of adjacent variable cells
I misunderstood. Try this
=sumproduct((d3:f31="bags")*c3:c31)
--
Don Guillett
SalesAid Software
"michaelberrier" wrote in message
oups.com...
Don,
Thanks for looking. This only tells me how many times that word shows
up in the list. I would like to add the numbers adjacent to that word
as they represent a quantity. I'm thinking an Offset would work as
the quantity is always the cell to the left of the value, but I'm not
sure how to write that.
On Mar 27, 10:11 am, "Don Guillett" wrote:
to count bags where f6 contains "bags"
=COUNTIF(Sheet12!A:F,F6)
--
Don Guillett
SalesAid Software
"michaelberrier" wrote
in message
oups.com...
There are several lists of items in the range D3:F31. In the same
range, beside the items are quantities, like so
5 Bags
3 Boxes
2 Carts etc,
Many of the items are duplicated throughout the multiple lists, so I'd
like a total quantity of each item. I've copied all the items to a
master list, but I'm stumped on the function to pull the individual
values out of each list for each item...I'm guessing it's a SUMIF, but
I'm not sure how to make it work.
Thanks in advance.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett