Adding data from one column using another
Solved/Closed
saltod
saltod
- Posts
- 2
- Registration date
- Tuesday August 25, 2009
- Status
- Member
- Last seen
- August 27, 2009
saltod
- Posts
- 2
- Registration date
- Tuesday August 25, 2009
- Status
- Member
- Last seen
- August 27, 2009
Related:
- Adding data from one column using another
- Data validation multiple columns - Guide
- Excel - Compare data from two columns - How-To - Excel
- Copy data from one column to another excel - Guide
- Copy range data in a column to new column. ✓ - Forum - Excel
- Need to find a data in a column and copy below cell data or add ✓ - Forum - Excel
1 reply
venkat1926
Aug 26, 2009 at 08:05 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Aug 26, 2009 at 08:05 PM
supose your data is A1 to B15 like this
1/1/2009 1
1/2/2009 2
1/3/2009 3
1/4/2009 4
1/5/2009 5
1/6/2009 6
1/7/2009 7 ****
1/8/2009 8
1/9/2009 9
1/10/2009 8
1/11/2009 7 ****
1/12/2009 6
1/13/2009 5
1/14/2009 4
1/15/2009 3
in any empty cell outside these two columns copy paste this formula
=SUMPRODUCT(($A$1:$A$200<"1/12/09"+0)*($A$1:$A$200>"1/6/09"+0)*($B$1:$B$200))
you will get 39
"***" in column c is only to show you the borders to check the sum
I have made provision for maximum of 200 rows. if necessary modify the formula.
1/1/2009 1
1/2/2009 2
1/3/2009 3
1/4/2009 4
1/5/2009 5
1/6/2009 6
1/7/2009 7 ****
1/8/2009 8
1/9/2009 9
1/10/2009 8
1/11/2009 7 ****
1/12/2009 6
1/13/2009 5
1/14/2009 4
1/15/2009 3
in any empty cell outside these two columns copy paste this formula
=SUMPRODUCT(($A$1:$A$200<"1/12/09"+0)*($A$1:$A$200>"1/6/09"+0)*($B$1:$B$200))
you will get 39
"***" in column c is only to show you the borders to check the sum
I have made provision for maximum of 200 rows. if necessary modify the formula.
Aug 27, 2009 at 02:57 AM