dividng numbers using the sumif function

[tiare1021]

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,

 

[Mike H]

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

 

[Mike H]

Make sense?

I'm afraid it doesn't no. Sumif sums a range based on some criteria and you
haven't told us the criteria for summing either range

for example

=SUMIF(B3:B12,">4")

sums numbers in the range larger than 4

Mike