+ Reply to Thread
Results 1 to 2 of 2

Multiple Criteria for COUNTIF and SUMIF

  1. #1
    nils_odendaal
    Guest

    Multiple Criteria for COUNTIF and SUMIF

    I have data in three columns. I need to count occurances and sum numbers
    between these columns. I have used the following formulas to get one set of
    data:

    =COUNTIF(A:A,"Species")
    =SUMIF(A:B,"Species",B:B)

    Now I need to get to get the number sightings of animals (i.e. 1 group of 10
    individuals observed at a certain distance) AND the number of individuals
    (Col B) of species (Col A) observed at a certain distance (Col C) . For
    example, elephant (Col A), 2 (Col B), >500 (Col C).

    Can anyone please assist me?

    Thanks, Nils

  2. #2
    Bob Phillips
    Guest

    Re: Multiple Criteria for COUNTIF and SUMIF

    Nils,

    It would be something like

    =SUMPRODUCT((B2:B25>500)*(C2:D25="Species")*(A22:B25))

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "nils_odendaal" <nils_odendaal@discussions.microsoft.com> wrote in message
    news:89ADAFE4-6525-4B9A-80E9-E42C5D7B84F0@microsoft.com...
    > I have data in three columns. I need to count occurances and sum numbers
    > between these columns. I have used the following formulas to get one set

    of
    > data:
    >
    > =COUNTIF(A:A,"Species")
    > =SUMIF(A:B,"Species",B:B)
    >
    > Now I need to get to get the number sightings of animals (i.e. 1 group of

    10
    > individuals observed at a certain distance) AND the number of individuals
    > (Col B) of species (Col A) observed at a certain distance (Col C) . For
    > example, elephant (Col A), 2 (Col B), >500 (Col C).
    >
    > Can anyone please assist me?
    >
    > Thanks, Nils




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1