 |
|
|
|
Next: I'm using Flip Mino HD, and i want to post my vid..
|
| Author |
Message |
External
Since: Feb 4, 2010
Posts: 1
|
(Msg. 1) Posted: Thu Feb 04, 2010 8:06 am
Post subject: How to make a SumIf range not a range ... but a sum of specific cells
Archived from groups: microsoft>public>excel (more info?)
|
|
|
|
|
| Back to top |
|
 | |
External
Since: Dec 2, 2008
Posts: 56
|
(Msg. 2) Posted: Thu Feb 04, 2010 10:27 am
Post subject: Re: How to make a SumIf range not a range ... but a sum of specific
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Oct 22, 2008
Posts: 20
|
(Msg. 3) Posted: Thu Feb 04, 2010 11:56 am
Post subject: Re: How to make a SumIf range not a range ... but a sum of specific cells
Archived from groups: per prev. post (more info?)
|
|
|
Another way...
Assuming that if D3 does not equal AL3 then you want a result of 0.
=(D3=AL3)*SUM(H3,J3,L3,N3,P3,R3,T3,V3,X3,Z3,AB3,AD3) >> Stay informed about: How to make a SumIf range not a range ... but a sum of spe.. |
|
| Back to top |
|
| |
External
Since: Dec 8, 2008
Posts: 11
|
(Msg. 4) Posted: Thu Feb 04, 2010 4:25 pm
Post subject: Re: How to make a SumIf range not a range ... but a sum of specific cells
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
| Related Topics: | how to populate a range with another range of data ? - Hi - imagine that I have 2 worksheets in my workbook. Worksheet 'MASTER' 5 columns x 4 rows Column 1 = KEY and Columns 2 - 5 = numbers (data) Worksheet 'DATA' 4 columns x 12 rows (3 groups of 4 rows) I have been trying to use a combo-box t...
Range of an Excel Sheet - I want to open a linked Excel Sheet with the appropriate range. The excel filename / range I have is the following: C:\Documents and Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2 I'm opening the following by stripping of the extra information...
Using Named Range in LOOKUP formula? - My LOOKUP formula currently reads: =((LOOKUP($I6,$A$2:$A$7,$D$2:$D$7)-J6)+(LOOKUP($I6,$A$2:$A$7,$G$2:$G $7))) I would like to change this so the ranges are columns in a Named Range. Something like: =((LOOKUP($I6,Range_Col1,Range_Col4)-J6)+..
Counting Soecific dates in a range - Hi, I have a series of dates in A3:A1000 and I only want to count the dates in September 2009 **/09/09 (UK date format) in that range. I looked at COUNT, COUNTIF etc. but they only seem to look for text strings. I seem to be going around in circles..
need help on macro/VBA programming selecting a range - I would like a macro to allow a user to select a cell in column A on Sheet 2. If the user selects A6 I would like the macro to select the Range (A6:BF6) in Sheet2 and copy that to Sheet1 starting in cell A1. Thank You in advance. Ron |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
