Forum Discussion
SUMIF for a range of one cell and a sum range of 242
Perhaps formula in GGP6 could be
=IF($M6=GGP$2,SUM($N6:$IU6),0)+IF($IY6=GGP$2,SUM($IZ6:$SG6),0)and copy it to the right and next rows. Other ranges could be added same way.
I think you are considering the wrong formula here...what I believe you need is :#
=IF(C8=1,SUM(D8:IK8),FALSE)
Charla74 - many thanks for your kind reply. Just to clarify, there are many thousands of cells in the worksheet that have a value entered in to the cell reserved for months (1 for Jan to 12 for Dec) and alongside each one of these "month" cells, there are 242 cells in the same row, with values in them. I then have 12 columns to the far RHS of the worksheet that totalisers for each month. Every time a "1" appears in one of the month cells, I need to add up the values in the 242 cells in the same row to the immediate right of the month cell and that total value will then appear in the January totaliser column to the far right. Hope this clarifies........all feedback welcome!
- Just to further clarify, if I trace precedents having entered the formula, all the correct cells are "boxed" - just the SUM is wholly wrong.
Maybe i'm still not aligned with the result you're looking for but see attached my updated version of your sheet and an additional suggestion sheet which may (or may not) be of use.
The problem I see with your initial formula is that you are only asking for one condition (1) where there are a possible 12 conditions...
