SUMIF a text formula

Hi Jackies, welcome to the forum.

Are you just looking to sum various cell values?

=SUM(A1,A2,A3)

or

=SUM(A1:A3)

I'm afraid you'll have to post an example workbook, as I'm still not understanding it for some reason. In the sample, provide data that matches your real data in format, variety and layout, and then show what your expected results should be and why.

Thanks!

If the answer is supposed to be 3200, you could use something like:

=INDEX(E4:E25,MATCH("A1",A4:A25,0))+INDEX(E4:E25,MATCH("A2",A4:A25,0))+INDEX(E4:E25,MATCH("A3",A4:A25,0))

It's simply looking for each reference in column A and returning the corresponding value from column E, then adding them together.

Another option would be to give the cells you want to total a defined name. You can't define a name as A1, A2 and A3 though, as those already are named ranges (cells A1, A2 and A3). If you named them "TA" (for Total Assets), "TL" (for Total Liabilities) and "SCR" (for Share Capital and Reserves) you could then type a formula like:

=TA+TL+SCR

If neither option works, a UDF could be coded so that you could essentially do the INDEX/MATCHING from the first example, but in the cell you would only have a small function, like

=MySum(TA,TL,SCR)

Perhaps try

=SUM(SUMIF(A2:A26,{"A1","A2","A3"},E2:E26))

Thanks guys for your input

The file I have attached is an example of how the data is retrieved and should be presented in the report. However, the actual Jet Report retrieves information from Navision and I use IF statements to guide the formula what to do with the data. My formula is in a single cell to perform dynamically.

I want a formula that can interpet Totaling column and triger SUMIF function. So far I was able to use SUMIF where - for example - Totaling value is 2 and I add all the Amount cells with Row No. 2. In the case of addition like A1+A2+A3, the formula has to identify A1, A2 and A3 and perform separate SUMIF for each one, adding the results at the end.

I have attached the actual file created with Jet Reports and the IF, SUMIF statements in cell I7