Need a formula to calculate all total purchase from different sheets by acct number

Hello, as the title suggest...kindly please help me on the formula for calculating total purchase by acct number from different sheets, the sample scenario i provided was only consist of 1 sheet but i know but i know guys you know how this thing works, i am currently looking for possibility of sumif or sumifs but i couldnt get the hang of it..please help me i've been on a dilema on this ..thanks

Here you have UDF

Please Login or Register  to view this content.

You shoul use this function, where without sheet AFTER. And after calculating this function you shoul past values.
For this problem better would be macro.

Here you have UDF

Please Login or Register  to view this content.

You shoul use this function, where without sheet AFTER. And after calculating this function you shoul past values.
For this problem better would be macro.

thanks for your reply and time for giving solution, however i still don't know how to use UDF yet ehehe how can i use this or much better if you have simplier formula or other way for this hehe thanks really appreciate this

need help please...i really need this

Consolidation is the best way, of course. The second is run a macro.
There are many, many examples, how create UDF, i.e.
http://www.youtube.com/watch?v=czgrImckn2g

On AFTER Tab and in Cell D2:

=SUM((File2!$A$2:$A$19=A2)*(File2!$C$2:$C$19))

Array Formula (hit CTRL-SHIFT-ENTER together)

and copied down

Azumi

Pl see attached file.

Originally Posted by :) Sixthsense :)

What i suggest is just consolidate all the sheets data in to a single sheet as a continuous data. So that the result can be arrived easily by using a simple SUMIF().

If consolidating of data is not possible then we have to go for a complicated approach like VBA or Using Named Range With Indirect Combination for getting the result.

Thanks for your reply and ideas bro (y)

Originally Posted by hudibyk

Consolidation is the best way, of course. The second is run a macro.
There are many, many examples, how create UDF, i.e.
http://www.youtube.com/watch?v=czgrImckn2g

thanks for this, i watched it and hope i can use this someday hehe

Originally Posted by kvsrinivasamurthy

Pl see attached file.

Originally Posted by azumi

On AFTER Tab and in Cell D2:

=SUM((File2!$A$2:$A$19=A2)*(File2!$C$2:$C$19))

Array Formula (hit CTRL-SHIFT-ENTER together)

and copied down

Azumi

thanks for the sample @Azumi and kvsrinivasamurthy

wow thanks for your replies guys sorryy for the late reply as i took a leave on my work and just got return today ehhe...it works fine now using the formula by Azumi and kvsrinivasamurthy..really appreciate the time and effort on this...+ rep to all of you thanks again :D