Sum Indirect Formula

[oberhrc]

Hello,


I need some help, I have a spreadsheet that the columns are not lining up and I need to sum across based on the same data. Columns B3 (April) has 300 rows, Column G3 (May) has 295 rows and Column L3 (June) has 301 rows. I need to do a sum across based on the data in columns B3, G3 and L3.


I apologize in advance if I'm not making this clear.


Thanks for all your help!

 

[sdsurzh]

=SUM(A2:A400) =SUM(B2:B400) =SUM(C2:C400)

21 49 84

19 59 89

10 41 88

22 54 83

24 50 85

25 55 75

28 38 64

23 32 89

19 45 76

14 31 62

Col A Col B Col C


Are you looking this kind of information

 

[Faseeh]

Hi oberhrc,


If your data is present like this:

[pre]

April	May	June
89
125		88
126		56
127	1255
128	1220
132	1211
130	1200
120	1266
125
130[/pre]
...simply use =SUMPRODUCT((B1:L1="APRIL")*(B2:L21))

where B1:L1 contains the month name and B2:L21 contains your data set.


Regards,

Faseeh