What I have is a self created data base. I have two columns that i need to include in this formula. One of the columns has names(column A, range=B2:B156) and the other has numbers (Column B, range=E2,E156). I need the formula to detect specific names in column A while counting numbers in the same row from column B.
see SUMIF function in XL Help - also you might wish to consider using a Pivot Table (general intro link in my sig.)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks