Hi,
I am trying to pull the below formula to the cells I44,J44,K44,L44
In cell G44 =SUMIFS(G2:G40,D2:D40,"Offshore",E2:E40,"Active")
In cell H44 =SUMIFS(H2:H40,D2:D40,"Offshore",E2:E40,"Active")
I need it to be updated automatically as
In cell I44 =SUMIFS(I2:I40,D2:D40,"Offshore",E2:E40,"Active")
but it is updating as
=SUMIFS(I2:I40,F2:F40,"Offshore",G2:G40,"Active")
can someone provide me some ideas on how to fix this issue
Admin - please delete this topic as I have opened another one with some more details and attachment
Originally Posted by abdulji
I will close this for you, but for future reference, please stay with the thread you created and update it as needed, dont start a new thread, as it will be closed as a duplicate
for what it's worth, all you needed to do was add some absoluting/locking...
=SUMIFS($G$2:$G$40,$D$2:$D$40,"Offshore",$E$2:$E$40,"Active")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks