I need to have the total count of times "Seller" "Landlord" and "Both" appear in column E in 2005.
Obviously, if I add anymore criteria in this formula it will require the entry to have all three categories in order to count it.
=COUNTIFS(Deals!$E$2:$E$500,"Seller", Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<=1/1/2006")
Is this a function for SUMPRODUCT?
Thanks!
See if this works for you...
=SUM(COUNTIFS(Deals!$E$2:$E$500,{"Seller","Landlord","Both"}, Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<=1/1/2006"))
HTH
Regards, Jeff
You guys are really outstanding. Thank you so much!!!!!
I'm new to using {}, do these indicate an array? (Not much experience with these yet)
Essentially yes and you are very welcome, glad it worked out for you.
================================================================
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I assume that there is Date column which is in A column: then
=SUMPRODUCT((YEAR(A:A)=2005)*(C:C="Seller"))
Ah there is a date column, I'm surprised no one yet has offered me this particular formula...
Try..
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks Ace!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks