Re: SUMIF [sum_range] / sorting question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Jun 16, 12:31 pm, jiml <j...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Suppose I have data that looks like:

1/1/2008 1/3/2008 2/7/2008
Ordered Ordered Ordered
Aardvarks 8 7 3
Baboons 3 10 7
Cats 5 3 2
Ducks 5 1 7
Elephants 7 2 8

I want to get, by month, the total of animals on another sheet

January February
Ordered Ordered
Ducks 6 7
Aardvarks 15 3
Elephants 9 8
Baboons 13 7
Cats 8 2

The tricky part is that I can't control what rows will go where. The two
lists sorting order will change, and new items might be added at any time
(say the zoo wants to add Flamingoes and Giraffes)

That is, for the first sheet, you might see Aardvarks, Baboons, Cats, Ducks,
Elephants, but you could also see Baboons, Elephants, Cats, Aardvarks, Ducks.

Likewise for the second sheet; the rows could be in any order.

Any suggestions?

Well, if there is only ever one row of each animal, a simple VLOOKUP
will do the trick. If there is more than one row, probably a SUMIF or
certainly a SUMPRODUCT would work. Or, if it is more than one row and
this is a massive number of formulas that you will need, eventually
DSUM would be faster than the SUMxx formulas.
.

Relevant Pages

  • Re: SUMIF [sum_range] / sorting question
    ... Ducks 6 7 ... Elephants 9 8 ... Baboons 13 7 ... Cats 8 2 ...
    (microsoft.public.excel.worksheet.functions)
  • QCs adventures
    ... It was a glorous day for the dark, furry traveler who was wearing a ... cats in a brown leather vest came in hollering "help, help, my ducks ... The dark furry traveler looked over at ... Do you have any ducks ...
    (rec.pets.cats.anecdotes)
  • Re: my recent project
    ... Could you put up a closer shot of it? ... couple of cats, and perhaps I should make something like that. ... be frightened by an umbrella pointed directly at them opening. ...
    (rec.crafts.metalworking)
  • Re: Final Solution of the Aquatic Question - Retroviruses
    ... so would any animal sharing the same habitat as baboons - did ... > usually mean 'big cats'. ... >>> suggests that human ancestors did NOT at ... Didn't other hominoids and big cats also show aggressive tendencies ...
    (sci.anthropology.paleo)
  • Dumb and Dumber
    ... Yesterday, the fox was back. ... He lost all his ducks to the fox. ... The dog is allegedly good with kids and adults. ... Complete unknown with cats, chicken, ducks, .... ...
    (rec.pets.dogs.behavior)