Hi,
Would appreictae some info on how to offset a named range within a sumif function.
e.g.
I have in cells A1:A4 some words and this range has been names as test.
In my sumif function:
Range = 'test' (i.e. A1:A4)
Criteria = cow (i.e. suppose A1 and A2 are 'cow')
Sum Range = C1:C4 (I want this range to be as a function of 'test')
How can I make it that the value of C1 and C2 are added together such that the sum range is a function of A1 and A2?
I have this.
=sumif(test,"cow",offset(test,2,0) --> how can this be changed?
in essnece =sumif(a1:a4,"cow",c1:c4)
Many thanks and appreciate any help.
Bookmarks