No announcements

### Need Excel 365 formula to sum amounts in colored cells

Hi, I have some amounts in column A, B & C for eg., and some of the amounts are yellow colored, I need an ...
| 1 Replies | 899 Views | Created by Raaj306 - Sunday, November 1, 2020 11:37 AM | Last reply by sysmod - Wednesday, November 18, 2020 5:51 PM

### Excel formula fun - sum cells based on column headings.

Hello everyone, I'm stuck on a formula and I was hoping someone could help me with it. I'm trying to put ...
| 3 Replies | 15546 Views | Created by pete6256 - Monday, July 30, 2012 3:50 PM | Last reply by RichLocus - Tuesday, July 31, 2012 1:44 AM

### Sum offset excel formula

Then subtract the first column number from the last column number +1 to get the width of sum range in Offset formula. Hope you get this ...
| 5 Replies | 2976 Views | Created by Ninim - Thursday, July 26, 2012 7:26 PM | Last reply by Somkiat Foongkiat - Bangkok, Thailand - Tuesday, July 31, 2012 3:33 AM

### Naming colored cells

;tried  a sub to assign the colors,  but it doesn't work.  Basically, I get a spreadsheet and column 19 is colored.  I need to insert ...
| 2 Replies | 858 Views | Created by DeanJW2006 - Thursday, June 20, 2013 5:48 PM | Last reply by DeanJW2006 - Thursday, June 20, 2013 8:15 PM

### Formula cells in excel using openXML

Hi, Please explain how to create formula cells in excelsheet using openXML in ...
| 5 Replies | 40319 Views | Created by Elangovan Panneerselvam - Wednesday, December 14, 2011 5:20 AM | Last reply by Shawnnosaurus - Monday, October 3, 2016 7:39 AM

### Need excel formula

I need help with creating a formula in excel. Answer may be simple but I don't know it. If I have one fixed cost (labor) in a cell and i want to ...
| 2 Replies | 3781 Views | Created by Keifo - Thursday, April 14, 2011 2:05 AM | Last reply by Keifo - Wednesday, April 20, 2011 1:46 AM

### excel export sum of cells problem in ssrs report

(Report Builder and SSRS) After export the report to Excel format, we can also aggregate the values in Excel file. Based on my test, we can ...
| 1 Replies | 1751 Views | Created by Rishabh Patil - Monday, July 28, 2014 6:18 AM | Last reply by Katherine Xiong - Tuesday, July 29, 2014 7:32 AM

### conditinal SUM formula

I need to have a forum;a that will give me something like sheet1.(row3,cell5) = sum(sheet2.columB) if sheet2.columnD = OK Can anyone ...
| 1 Replies | 323 Views | Created by o2code - Monday, September 29, 2014 3:05 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Monday, September 29, 2014 4:28 PM

### vba excel, cell formula, set formula using VBA to sum a range in a row

; How do I refer to columns in a formula by column number so that I can make the cell formula sum a row? For intCol = 18 ...
| 1 Replies | 5453 Views | Created by GordonGecko - Thursday, February 21, 2013 4:07 PM | Last reply by Hans Vogelaar MVP - Thursday, February 21, 2013 4:34 PM

### Formula in excel not working when populate cells using openxml

Hi everyone . I have a excel file as template that is include 3 cells . Tow cells are number and in another cell a formula has been ...
| 3 Replies | 3924 Views | Created by Mohammad Modrek - Sunday, October 13, 2013 7:47 PM | Last reply by Mohammad Modrek - Friday, November 1, 2013 6:52 PM

### Cells do not get colored

I have the code for transferring data from the datagridview to the excel spreadhseet.. my datagridview has colored data in it and I want the ...
| 1 Replies | 3945 Views | Created by kavita bhaskaran kukkala - Monday, August 18, 2008 2:28 PM | Last reply by kavita bhaskaran kukkala - Thursday, August 21, 2008 7:58 PM

### Trying to create a sum formula within Excel

I have a column in excel where lines 1-15 have drop down menus. What I am trying to do is write a formula in a different cell that will look at that ...
| 1 Replies | 534 Views | Created by John 35 - Tuesday, March 4, 2014 9:16 PM | Last reply by Hans Vogelaar MVP - Tuesday, March 4, 2014 9:51 PM

### Excel VBA issue with protecting formula cells in all worksheets

merged cells; must test in individual cells and hence only the first cell of the merged range has a formula. If a cell is not merged then Set ma ...
| 4 Replies | 2729 Views | Created by zaveri cc - Friday, June 27, 2014 6:21 PM | Last reply by zaveri cc - Monday, June 30, 2014 2:02 PM

### How to exclude amounts from the SUM

> I simply want to sum up the WPAMT data and exclude any amounts where column WPTYP='AD' AND column WPTYCD='SB'. (Both have to be true before excluding) <
| 6 Replies | 544 Views | Created by Jakets25 - Monday, October 23, 2017 4:32 PM | Last reply by Jakets25 - Thursday, November 9, 2017 2:12 PM

### SUM(IF( formula

Having a hard time writing a formula in RS...   Trying to say if the funding date is equal to today or before the
| 1 Replies | 6453 Views | Created by mkirby - Friday, January 18, 2008 6:58 PM | Last reply by Jacob Sebastian - Saturday, January 19, 2008 1:16 PM

### Count Colored Cells from Conditional Formatting

Hi LoisWM, When we want to know the colored cells which are colored with Conditional Format, we need to ...
| 9 Replies | 1211 Views | Created by LoisWM - Saturday, December 7, 2019 9:48 PM | Last reply by Ashidacchi - Tuesday, December 10, 2019 4:14 AM

### Sum formula in data base

Hi, You should be more spercific here. If you mean by use linq to sql do query the input numbers, the get the sum total: public static ...
| 1 Replies | 3227 Views | Created by JLUCASCT - Thursday, August 27, 2009 9:16 PM | Last reply by Bin-ze Zhao - Wednesday, September 2, 2009 5:19 AM

### Sum cells by data!

If the word Red apears in cells (J1:J30) it will Sum totals in (K1:k30) Red Jacket       ...
| 5 Replies | 1998 Views | Created by TurnipOrange - Thursday, November 10, 2011 2:02 AM | Last reply by Hans Vogelaar MVP - Thursday, November 10, 2011 5:47 PM