Forum Discussion
Solved
Please Help
I have a problem that I have been trying to resolve for at least a day now, and I cannot see why my formula is not working with some SUMIF calculations, but then reports back "0" when is should conta...
The ranges in SUMIF should be the same size, but the real problem is that the amounts in column I are not in the same row as B&M in column C.
Would the amount always be 4 rows down from the row with B&M? I suspect not...
The ranges in SUMIF should be the same size, but the real problem is that the amounts in column I are not in the same row as B&M in column C.
Would the amount always be 4 rows down from the row with B&M? I suspect not...
- Thank you Hans. I will check that out!
I got what you told me, and I have managed to fix the problem. Maybe not in a conventional way, but I copied the 'supplier name' and then pasted 'special' in the row that had the 'total' in column 'I'. Hey presto. Thank you 😊. . . To keep the entries looking tidy, I changed the font to white, so that entry was no longer visible!
