conditional adding through sheets in a loop. Novice.

[av_raje]

Hi
Total Excel progamming novice here.
Boss summoned me to do a quick programming.

In an excel sheet he has got 5 worksheets with a list of medicines and quantity of drugs in the 5 pharmacy branches. The medicines are not in order in the sheets.

Basically I have to write a code to add the quantities of each drug and make a separate column in another excel file.



If I had the time I would read a lot about it, but now I need a quick fix please.

[Bob Phillips]

Why does your boss give this job to a novice. Is he dumb?

Use a formula

=SUMIF(Sheet2!A:A,"medicine 1",B:B)+SUMIF(Sheet3!A:A,"medicine 1",B:B)+ etc.

[av_raje]

Well I am a entry level programmer here, but have used excel only for basic data functions.

Thanks for the code.

I stick that SUMIF in a loop don't I, in which case syntax for loop please

[Bob Phillips]

No, it is a worksheet function so you stick it on the summary worksheet. One set of SUMIFs for each medicine. Smart money would say create a list of medicines and refer to these in the SUMIF formulae.