iggydarsa
Well-known Member
- Joined
- Jun 28, 2005
- Messages
- 1,734
- Office Version
-
- 2019
- Platform
-
- Windows
Hi All,
I have a sheet that looks like this (except the column C):
<html><head><title>Excel Jeanie HTML</title></head><body>
<!-- ######### Start Created Html Code To Copy ########## -->
<!-- ######### End Created Html Code To Copy ########## -->
</body></html>
I would like to know the dates occured per person; however, because the names are appearing only once I cannot find a way to use SUMIF or SUMPRODUCT... any ideas?
I have a sheet that looks like this (except the column C):
<html><head><title>Excel Jeanie HTML</title></head><body>
<!-- ######### Start Created Html Code To Copy ########## -->
| Excel Workbook | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Name | Date | Total | ||
| 2 | Adam | 1/1/2008 | 3 | ||
| 3 | * | 1/5/2008 | * | ||
| 4 | * | 1/7/2008 | * | ||
| 5 | * | * | * | ||
| 6 | Bob | 1/2/2008 | 4 | ||
| 7 | * | 2/5/2008 | * | ||
| 8 | * | 2/6/2008 | * | ||
| 9 | * | 3/3/2008 | * | ||
| 10 | * | * | * | ||
| 11 | Charlie | 2/4/2008 | 1 | ||
| 12 | * | * | * | ||
| 13 | David | 2/7/2008 | 2 | ||
| 14 | * | 2/8/2008 | * | ||
Sheet2 | |||||
<!-- ######### End Created Html Code To Copy ########## -->
</body></html>
I would like to know the dates occured per person; however, because the names are appearing only once I cannot find a way to use SUMIF or SUMPRODUCT... any ideas?
