Forum Discussion

Matt_7's avatar
Matt_7
Copper Contributor
Apr 25, 2020
Solved

SUMIF for a range of one cell and a sum range of 242

Dear All, help greatly appreciated!   I have approx 300 sections on one worksheet. Each section has 40 individual cells, each containing a value between 1 to 12 (denoting months of the year). Along...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 25, 2020

    Matt_7 

    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.

Charla74's avatar
Charla74
Iron Contributor
Apr 25, 2020

Matt_7 

 

I think you are considering the wrong formula here...what I believe you need is :#

 

=IF(C8=1,SUM(D8:IK8),FALSE)

Resources