| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding certain cells in one column
In my spreadsheet cells in the range E1 through E80 contain total dollar
calculations from each of the columns to their left. Corresponding cells in column G contain either an X or a Y. I need a formula that scans column G for all occurrances of Y, then ads together the total of the corresponding cells in column E. APpreciate any help! JT |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding certain cells in one column
Try this
=SUMPRODUCT((G1:G80="y")*(E1:E80)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "JT" wrote: In my spreadsheet cells in the range E1 through E80 contain total dollar calculations from each of the columns to their left. Corresponding cells in column G contain either an X or a Y. I need a formula that scans column G for all occurrances of Y, then ads together the total of the corresponding cells in column E. APpreciate any help! JT |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding certain cells in one column
Would a SUMIF do the same thing?
"Mike H" wrote: Try this =SUMPRODUCT((G1:G80="y")*(E1:E80)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "JT" wrote: In my spreadsheet cells in the range E1 through E80 contain total dollar calculations from each of the columns to their left. Corresponding cells in column G contain either an X or a Y. I need a formula that scans column G for all occurrances of Y, then ads together the total of the corresponding cells in column E. APpreciate any help! JT |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding certain cells in one column
Yes
=SUMIF(G1:G80,"=y",E1:E80) Gord Dibben MS Excel MVP On Tue, 30 Mar 2010 17:11:02 -0700, Nadine wrote: Would a SUMIF do the same thing? "Mike H" wrote: Try this =SUMPRODUCT((G1:G80="y")*(E1:E80)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "JT" wrote: In my spreadsheet cells in the range E1 through E80 contain total dollar calculations from each of the columns to their left. Corresponding cells in column G contain either an X or a Y. I need a formula that scans column G for all occurrances of Y, then ads together the total of the corresponding cells in column E. APpreciate any help! JT |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding certain cells in one column
=SUMIF(G1:G80,"y",E1:E80) works as well.
Gord On Tue, 30 Mar 2010 17:29:32 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Yes =SUMIF(G1:G80,"=y",E1:E80) Gord Dibben MS Excel MVP On Tue, 30 Mar 2010 17:11:02 -0700, Nadine wrote: Would a SUMIF do the same thing? "Mike H" wrote: Try this =SUMPRODUCT((G1:G80="y")*(E1:E80)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "JT" wrote: In my spreadsheet cells in the range E1 through E80 contain total dollar calculations from each of the columns to their left. Corresponding cells in column G contain either an X or a Y. I need a formula that scans column G for all occurrances of Y, then ads together the total of the corresponding cells in column E. APpreciate any help! JT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells in every other column | Excel Discussion (Misc queries) | |||
| Adding specific cells in column | Excel Worksheet Functions | |||
| adding individual cells in a column | Excel Worksheet Functions | |||
| Adding cells in a column | Excel Discussion (Misc queries) | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Linear Mode
