Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Sub SumIfs() Dim cel As Range For Each cel In Range("AZ6:AZ10") Dim str As String str = cel.Offset(0, -4).Address cel = Application.WorksheetFunction.SumIf([AllConfigs], str, [AllJ]) Next End Sub End Sub
|How can I sort the data shown in Sheet 1 and copy it to Sheet 2?||8||22|
|Macro to Refresh the Hyperlinks without opening the source files||1||36|
|Excel Power Query Allow User to Input any Number on Parameter||2||29|
|How do I update en Excel formula to include the woksheet name?||2||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!