| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total a column contingent upon the cell to the right being non-bla
I need a total from Column C for each cell which has an adjacent cell in
Column D that is non-blank. -- Industrial Technology Teacher Timberlake High School Spirit Lake, ID |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total a column contingent upon the cell to the right being non-bla
=sumif(C:C,"<",D:D)
Regards, Fred "Ed Livingston" wrote in message ... I need a total from Column C for each cell which has an adjacent cell in Column D that is non-blank. -- Industrial Technology Teacher Timberlake High School Spirit Lake, ID |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total a column contingent upon the cell to the right being non
Fred meant to say
=SUMIF(D:D,"<",C:C) -- Jacob "Fred Smith" wrote: =sumif(C:C,"<",D:D) Regards, Fred "Ed Livingston" wrote in message ... I need a total from Column C for each cell which has an adjacent cell in Column D that is non-blank. -- Industrial Technology Teacher Timberlake High School Spirit Lake, ID . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total a column contingent upon the cell to the right being non
Thanks for the catch, Jacob. Must have been a little groggy last night.
Fred "Jacob Skaria" wrote in message ... Fred meant to say =SUMIF(D:D,"<",C:C) -- Jacob "Fred Smith" wrote: =sumif(C:C,"<",D:D) Regards, Fred "Ed Livingston" wrote in message ... I need a total from Column C for each cell which has an adjacent cell in Column D that is non-blank. -- Industrial Technology Teacher Timberlake High School Spirit Lake, ID . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
| IF function contingent upon cell not being blank | Excel Worksheet Functions | |||
| if a word is in a cell I want the total in that column | Excel Discussion (Misc queries) | |||
| In excel - how to total column if am not sure of the last cell | New Users to Excel | |||
| FORMULA TO MAKE CELL COLOR CONTINGENT | Excel Discussion (Misc queries) | |||
Linear Mode
