help me in coding for sumif formula

[vimalanathk]

Hi,

Please find the attached template and help me with the coding where i can use sumif condition.

Regards,
Vimala K

[FDibbins]

How do you want the answer shown?
This is teh basis of what you want...
=SUMIFS(Basic!B2:AT2,Basic!$B$1:$AT$1,Master!L2)

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[vimalanathk]

Hi John....

Its awesome and working fine.....

But i have multiple sheets in my original template which needs to be consolidate to the master sheet... sorry i didnt give this at the first instance... CC and order is common in all the sheets so in the column P if the Basic word is finished it should go to the next sheet based on the next text which is Conveyance.

please find the attached template for your reference.