| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF criteria in different column is met?
=SUMIF(A:A,"0-5 Years",B:B)
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "spandangled" wrote: this is slowly driving me mad... I'm looking to find the total number of sessions occuring in the age group 0-5 years. I tried to set age as a criteria and if the criteria was met to sum the number of sessions in the column opposite it, but I keep getting an error. Age No of Sessions (Half Days) 0-5 Years 2 17-19 Years 3 5-16 Years 6 0-5 Years 1 Any help would be hugely appreciated (I'm ready to drown myself in the fountain) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use sumif with OR to sum based on two column criteria? | Excel Worksheet Functions | |||
| SumIf formula from one column based on criteria from two other col | Excel Discussion (Misc queries) | |||
| Sumif 2 criteria - 1 in a Row and 1 in a Column | Excel Worksheet Functions | |||
| Sumif from two criteria in one column | Excel Discussion (Misc queries) | |||
| sumif with multiple criteria in one column | Excel Discussion (Misc queries) | |||
Hybrid Mode
