Ok so I have searched and haven't found anything, so I am asking for your great help!
I have 3 columns: months, city & name with hundreds of info. Here's a brief example
months City name
5 NY BOB
15 NY BOB
I want to find the average months that Bob, from NY has taken. So I used this fromula
=SUMPRODUCT((B2:B14="NY")*(C2:C14="BOB")*(A2:A14))/SUMPRODUCT((B2:B14="NY")*(C2:C14="BOB"))
Where the first fromula figures out the sum and the 2nd figures out the count. My question is there an easier formula to use where you can find the averages w/ using the Sumproduct? I'll attach the example.
Thanks
![]()
Bookmarks