| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of If Results. How?
I need to get the SUM of all cell values on 1 cell, that have a Particular
value in another cell. How do i do this? EG. Currently i use: =C33+F33+I33+R33+U33. However i need to get these values ONLY if another cell value has a certain Value in it. (These cells are C22,F22,I22,R22,U22). These are cells with a Validation list with 2 options in it. I ONLY want the sum of the values in the above (33 row's) IF the value in row 22 in the same colomn is a certain value. How do i do this ? COrey.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of If Results. How?
Assuming your values in row 22 is "Yes"
=SUMIF(C22:U22,"Yes",C33:U33) Tony Corey wrote: I need to get the SUM of all cell values on 1 cell, that have a Particular value in another cell. How do i do this? EG. Currently i use: =C33+F33+I33+R33+U33. However i need to get these values ONLY if another cell value has a certain Value in it. (These cells are C22,F22,I22,R22,U22). These are cells with a Validation list with 2 options in it. I ONLY want the sum of the values in the above (33 row's) IF the value in row 22 in the same colomn is a certain value. How do i do this ? COrey.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of If Results. How?
Cheers.
Donme well Tony. Corey.... "bony_tony" wrote in message ups.com... Assuming your values in row 22 is "Yes" =SUMIF(C22:U22,"Yes",C33:U33) Tony Corey wrote: I need to get the SUM of all cell values on 1 cell, that have a Particular value in another cell. How do i do this? EG. Currently i use: =C33+F33+I33+R33+U33. However i need to get these values ONLY if another cell value has a certain Value in it. (These cells are C22,F22,I22,R22,U22). These are cells with a Validation list with 2 options in it. I ONLY want the sum of the values in the above (33 row's) IF the value in row 22 in the same colomn is a certain value. How do i do this ? COrey.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
| Returning Numeric Results across a Single Row in Consecutive Cells | Excel Worksheet Functions | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
| calculating results in formulas | Excel Discussion (Misc queries) | |||
Linear Mode
