Hi,

I'm not quite sure what you mean, do either of these give the answer you want

=SUM(B3:B12)/SUM(Products!B4:B16)

or

=SUM(B3:B12)/COUNT(Products!B4:B16)

Mike

"tiare1021" wrote:

I need help in setting up a simple formula. I have 2 worksheet tabs -my
formula
is =Sumif(B3:B12)/Products(B4:b16) - in others I want to add numbers in
cells B3:B12 (tab 1) and divide the total by numbers in 2nd worksheet tab
B4:B16 using the sumif function since all cells already have formulas in
them. This is probably simple, but I don't grasp formulas very well, too
new. thanks,