I'm looking for some help with a formula. I have a dataset with repeated sites but with different number of visits per year. I could just do a simple formula for each separate site however, I have a couple hundred different sites surveyed at varying number of visits (see my Excel table for an example). The current formula is simple. It's just an average calculation (=C3/SUM($C$2:$C$11)
), but I would like to automate this so I can use the drag down but having the formula recognize when there has been a site name change and include the total in the formula for that specific site.
Add a comment
|
1 Answer
Use SUMIFS():
=C2/SUMIFS(C:C,A:A,A2)
-
Thank you! I knew it was something simple but I was using the SUMIF instead of SUMIFS. Much appreciated.– Ian FifeDec 15, 2020 at 21:02
-
@IanFife
SUMIF(A:A,A2,C:C)
would work also, I just personally like to useSUMIFS()
exclusively. Keeps from having to remember the different layout. Dec 15, 2020 at 21:07 -
@IanFife also remember to mark as correct if this helped answer you question. You do that by clicking the check mark beside the answer. Dec 15, 2020 at 21:08