SUMIF function

[Allerdrengen]

I am looking at this this function from a former employee: =IF(TRIM($B5)=TRIM($B6);"";SUMIF($B:$B;TRIM($B5);$AM$3:$AM:$AM)+SUMIF($B:$B;TRIM($B5);$AN$3:$AN:$AN))

which continues throughout:

=IF(TRIM($B6)=TRIM($B7);"";SUMIF($B:$B;TRIM($B6);$AM$3:$AM:$AM)+SUMIF($B:$B;TRIM($B6);$AN$3:$AN:$AN))
=IF(TRIM($B7)=TRIM($B8);"";SUMIF($B:$B;TRIM($B7);$AM$3:$AM:$AM)+SUMIF($B:$B;TRIM($B7);$AN$3:$AN:$AN))
=IF(TRIM($B8)=TRIM($B9);"";SUMIF($B:$B;TRIM($B8);$AM$3:$AM:$AM)+SUMIF($B:$B;TRIM($B8);$AN$3:$AN:$AN))

I was wondering what the $AM$3:$AM:$AM and $AN$3:$AN:$AN does. What do I achieve by having AM3 and AN2 incorporated, as opposed to just $AM:$AM and $AN:$AN.

Thanks!

[Special-K]

There appears to be no difference between

SUM(A2:A3:A4:A5:A6)
and
SUM(A2:A6)

or even
SUM(A2:A:A)
and
SUM(A:A)

I suggest you change them to the accepted range format of start:end, ie $AM:$AM

[TMS]

I've never seen that construct before. It may be an attempt to use SUMIF from row 3 for the rest of the column. However, I suspect that it may be redundant and not achieve its objective.

In the Immediate Window in the VB Editor:

Please Login or Register  to view this content.

[Allerdrengen]

Thank you for your responses. That is my conclusion too.

Regards

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.