Column name for Active cell and Sumif UDF (multiple criteria)

Namaste Everybody

Is there any way either with formula or VBA to get column name in current cell..

Please see attached sheet.. Also please help me to create UDF for this... It little time consuming process to new person to copy yellow marked region to new sheet and change reference accordingly.. I want to know is there any UDF for this which will directly handle formula in yellow marked region..

Formula:

Please Login or Register  to view this content.

Hi,

The current column letter can be obtained by this

=LEFT(ADDRESS(1,COLUMN(),2),1+(COLUMN()>26))

yes its working perfectly... Also can you help with UDF for that formula which if entered by any user will do all the work..???

I may be able to. Can you explain what your desired end result is and what is the necessity of the indirect referencing? Does the yellow table have to be below the main data, or could it be located elsewhere?

Desired Result is after applying filter to Bank Name(Say selected NEFT) difference should be zero of (see Row 30 .. Total- Grand Total) and after applying filter Sumif formula will automatically takes Total with multiple criteria (say I have selected NEFT Total Earning sum is 196095 and all diff in Row 30 is zero)..

No I cant locate it elsewhere because it is the summary for that particular month which is useful to make Bank wise payment (Say NEFT or other)..

Need of Indirect reference is my data is not fixed every month due to resignation and new joining..

see attached sheet.. I have applies filter and your formula (see row 30 diff is zero)...

Experts please help.. see desired result in post #5