0

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.

Excel table

1 Answer 1

0

Use SUMIFS():

=C2/SUMIFS(C:C,A:A,A2)
3
  • Thank you! I knew it was something simple but I was using the SUMIF instead of SUMIFS. Much appreciated.
    – Ian Fife
    Dec 15, 2020 at 21:02
  • @IanFife SUMIF(A:A,A2,C:C) would work also, I just personally like to use SUMIFS() 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .