Sum multi criteria
I have the attached. In column A is a list of states and column B provides a date. The date represents the date we received data from the branch located in the State in Column A.
Column F has a heading of State and Column G is Number by state. I want to sum the number of dates in column B by state that correspond with the state in column F. Can someone please help me?
Your profile states 2003 but the file is 2007 format... if you're using 2007
G2: =COUNTIFS($A$2:$A$7,$F2,$B$2:$B$7,">0")
copied down
For earlier versions
G2: =SUMPRODUCT(--($A$2:$A$7=$F2),--ISNUMBER($B$2:$B$7))
copied down
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
In G2 and copied down:
=SUMPRODUCT(--($B$2:$B$7>0),--($A$2:$A$7=F2))
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thank you
I now have 07. I will have to change my profile.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks