LinkBack URL
About LinkBacks
Hi ...
I have this formula: =SUMIFS(Stats[HS];Stats[HomeTeam];$B$8)
I want to copy it horizontally, but the [HomeTeam] keeps changing to the next column in the table/array
How do I stop that from happen?
In advance; Thanks
Hi ...
I have this formula: =SUMIFS(Stats[HS];Stats[HomeTeam];$B$8)
I want to copy it horizontally, but the [HomeTeam] keeps changing to the next column in the table/array
How do I stop that from happen?
In advance; Thanks
Try this.
=SUMIFS(Stats[HS],Stats[[HomeTeam]:[HomeTeam]],$B$8)
If posting code please use code tags, see here.
Thanks a lot!
It worked :-D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks