| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum results from 2 columns that meet criteria
Hi .. been trying to figure out formula for 2 days and can't seem to do it.
Would like excel to sum how many hires per month across several teams. I currently have data in 2 columns, e.g. Col A Col B Team Month DS May GF April DS April how do I write the formula so excel will look at column A, then B and total results per team per month. Thank you! -- Laura |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum results from 2 columns that meet criteria
=SUMPRODUCT(--(A2:A100="DS"),--(B2:B100="May")
"Laura Larson" wrote: Hi .. been trying to figure out formula for 2 days and can't seem to do it. Would like excel to sum how many hires per month across several teams. I currently have data in 2 columns, e.g. Col A Col B Team Month DS May GF April DS April how do I write the formula so excel will look at column A, then B and total results per team per month. Thank you! -- Laura |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| V lookup with 2 criteria to return results for multiple columns | Excel Worksheet Functions | |||
| Counting # of cells with that meet criteria in two columns | Excel Worksheet Functions | |||
| How do I count 2 columns of data that meet a certain criteria? | Excel Discussion (Misc queries) | |||
| count rows that meet two criteria in two different columns? | Excel Worksheet Functions | |||
| Rounding up results to meet minimum order quantities. | Excel Worksheet Functions | |||
Linear Mode
