Ive only opened my eyes to the potential of excel recently, but now im stuck on a formula (please note i dont know correct terms to use - sorry if it gets confusing like that)
ok i have a drop down boxs, lets call the names in them product 1, product 2, product 3 etc (in cells E18 - E28)… if u chose a product it automatically spits out a formula in cell G (so G18-G28 all the same formula)
now i need on a seperate sheet, to calculate how many times “product 1” (E cells) + its formula (in G cells) total too.
sheez im sure i make it sound allot more complicated that it is but i need help
It might be better if you put a little more detail in, I’m not sure I completely follow you, but if I understand you correctly, the formulas you are looking for are:
COUNTIF(range, criteria)
and
SUMIF(checkrange,criteria,sumrange)
So, on your other tab:
COUNTIF(‘Sheet1’!E18:E28,“Product1”)
repeat as necessary for Product2-ProductN
SUMIF(‘Sheet1’!E18:E28,“Product1”,‘Sheet1’!G18:G28)
again repeat as necessary.
On sheet one i have in Row B ,codes in drop down boxes - this pushes out name etc into row C + D and their salaries automatically will go into Row F, in row G is there overtime hours worked.
In row E i have a drop down box as to where the staff worked. (eg SOUTH AFRICA)
Now what i would like on sheet two is to make a analysis for say SOUTH AFRICA - a calculation of everytime it was used in the drop down box + the amount of overtime on that row it calculated - all added up.
This is so hard to put in words sorry
but thanks for the quick reply