Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dsum Function
That did work great.. thanks! This paticular database is very large and setting up the filter as described was time consuming. I may look into SUMIF for this particular application. I am happy to learn more about filtering and hope to put it in use on future spreadsheets. Sandie- sandieg
- Post #4
- Forum: Microsoft: Office
-
Dsum Function
I have a spreadsheet that uses DSUM but the criteria (which encompases two cells ie: D1 & D2 finds all simialar items ie: X0213M & X0213MP & X0213MPP when I only want to specify the first criteria. The function reads (=DSUM('M310+350'!$A2:$S6000,'M310+350'!$R2,C2:C3) The Criteria in C2 refers...- sandieg
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Find the end of one column
thanks a bunch...that helped- sandieg
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Find the end of one column
I need to find how many rows in column A in a spread sheet and then copy a formula down in Column B to the end of the data. I can copy it down but it goes to the end of the spreadsheet (6,000 rows). Thanks- sandieg
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
