| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to add (sum) specific cells
If i have a colum E1:E20 with a specific letter in each cell like A,B,C and
colum F,H,J with specific numbers, how can i ADD values that lies with A only and B only and C only? thank u... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add (sum) specific cells
Try:
=SUMPRODUCT(--(E1:E20="A")*(MOD(COLUMN(F1:J1),2)=MOD(F1,2)),F1:J 20) I assume you want to add data in columns F,H and J when E="A" "yodochi" wrote: If i have a colum E1:E20 with a specific letter in each cell like A,B,C and colum F,H,J with specific numbers, how can i ADD values that lies with A only and B only and C only? thank u... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add (sum) specific cells
Try something like this
=SUMPRODUCT(--(E1:E20="C"),(F1:F20)) HTH, Barb Reinhardt "yodochi" wrote: If i have a colum E1:E20 with a specific letter in each cell like A,B,C and colum F,H,J with specific numbers, how can i ADD values that lies with A only and B only and C only? thank u... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight specific cells in a row | Excel Discussion (Misc queries) | |||
| Summing specific cells! | Excel Worksheet Functions | |||
| Count cells with specific values in the cells next to them? | Excel Worksheet Functions | |||
| Tab to specific cells | Setting up and Configuration of Excel | |||
| Sum of specific cells | Excel Worksheet Functions | |||
Linear Mode
