J
Julie
I set up a table with a list of states in one column and amount of
tons in another column (ex from the book). I set up a conditional
format in a cell above the table to highlight all similar states when
entered in the above cell; ex: when I type IOWA, all IOWA listings
will be highlighted in the list. Then I tried a formula next to that
one that will add all the tons for each of the highlighted states. I
looked on the Internet and found a formula using MATCH but it only
entered the amount from the first IOWA, not the rest.
Does anyone have any idea how I would write that formula. Would I use
the COUNTIF function somehow?
tons in another column (ex from the book). I set up a conditional
format in a cell above the table to highlight all similar states when
entered in the above cell; ex: when I type IOWA, all IOWA listings
will be highlighted in the list. Then I tried a formula next to that
one that will add all the tons for each of the highlighted states. I
looked on the Internet and found a formula using MATCH but it only
entered the amount from the first IOWA, not the rest.
Does anyone have any idea how I would write that formula. Would I use
the COUNTIF function somehow?