Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Criteria for COUNTIF and SUMIF
Nils,
It would be something like =SUMPRODUCT((B2:B25500)*(C2:D25="Species")*(A22:B 25)) -- HTH RP (remove nothere from the email address if mailing direct) "nils_odendaal" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
Multiple SUMIF Criteria | Excel Worksheet Functions | |||
SUMIF With Multiple Criteria | Excel Worksheet Functions | |||
SUMIF, multiple criteria | Excel Discussion (Misc queries) | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions |