| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF criteria in different column is met?
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) |
|
#2
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF criteria in different column is met?
Hi Spandangled,
Try this: =SUMIF(A:A,"0-5 Years",B:B) Judith -- Hope this helps "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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF criteria in different column is met?
Hi,
Let's say you have the information in column A and in B the number of sesions, then starting in cell C1 you have again listed the group of ages you want to summarize, in D1 enter =sumproduct(--(C1=$A$1:$A$100),$B$1:$B$100) copy the formula down "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) | |||
Linear Mode
