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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jrobin9151
- Content: Threads
- Order by date
-
Multiple IFs within an Array
I put together the following formula based on blogs out there and it works fine: {=SUM(IF($B$1:$B$500="11_22",IF($L$1:$L$500=303,IF($M$1:$M$500>=1,$M$1:$M$500))))} The formula looks to column B and when it finds the Pay period "11_22" it looks to column L for cells that have series 303 listed...- jrobin9151
- Thread
- Replies: 21
- Forum: Microsoft: Office
-
Staffing Gains/Losses
Excel 2003 running on windows xp. I am trying to create a report that will return the gains and losses in staffing. Each pay period a roster from HR is given listing the names and work locations of the individuals. I am posting each data set into a seperate tab in the workbook. On the main or...- jrobin9151
- Thread
- Replies: 9
- Forum: Microsoft: Office
-
Select a radio button in Options Frame based on combo box selection
ACCESS 2003, Installed on a Network. I know this is probably easy to do can't remember it though. I have a combo box with several selections in the dropdown. Further down the form I have an Options group with four radio buttons that I've assigned the numerical value 1-4. When a user selects...- jrobin9151
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
