Hi, have an issue here, how do i able to drag the countifs formula without changing one of the criteria, for example:
Ship owners Bulker
ALP =COUNTIFS(Data!A:A,B19,Data!I:I,D1)
NOL =COUNTIFS(Data!A:A,B20,Data!I:I,D1)
thanks in advance! :D
Hi, have an issue here, how do i able to drag the countifs formula without changing one of the criteria, for example:
Ship owners Bulker
ALP =COUNTIFS(Data!A:A,B19,Data!I:I,D1)
NOL =COUNTIFS(Data!A:A,B20,Data!I:I,D1)
thanks in advance! :D
Try
=COUNTIFS(Data!$A:$A,$B19,Data!$I:$I,$D$1)
further to Bob's solution - be sure to check out the XL help files regards: relative, absolute, and mixed references
(very important to understand this if you are using XL regularly)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thanks you done a great help! :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks