How do I add a countif, averageif and sumif function

**susiesc** · 03-27-2013, 10:15 PM

I am told to create a report which is below but it says to use the COUNTIF, AVERAGEIF and SUMIF functions. And then to add a total at the bottom.

Ok I am confussed; can someone help me out wth this?

Customer Type Nbr Customers Avg Gallons Used Total Billed
Commercial 37 322,437 37,043.12
Nonprofit 11 87,661 224.18
Government 24 774,532 27,901.44

**Tank997** · 03-27-2013, 10:29 PM

OK is this your homework? Countif? What Averageif? What and Sumif if What?

**susiesc** · 03-27-2013, 10:36 PM

Yes this is for my homework; but I am now more confussed then ever.

**FDibbins** · 03-28-2013, 12:01 AM

Hi susiesc. It is the policy of this forum to not do your homework for you.

We will offer help with things you have already tried, and maybe suggest alternatives.

having said that...what have you done so far? what have you tried, what works and what didnt?

**susiesc** · 03-28-2013, 09:54 AM

After I created the report I lookd in the other sheets to see how I am able to link them but this is
not working. The only thing I can think of is adding the report to one of the sheets and then try it with a
blank report to bring over the numbers. This is impossible to do if there is nothing to refer to; what else can I do?

**susiesc** · 03-28-2013, 09:27 PM

This is what I put =COUNTIF(WaterData!B2:B73,A6) And it is not pulling over the count; what am I doing wrong?

**FDibbins** · 03-29-2013, 12:11 AM

here is the syntax for the functions you mentioned..

suppose you have range of cells 1 - 10 in A1:A10 and in B you have, alternating, A and B

COUNTIF = countif(range to count, criteria to base count on) =countif(A1:A10,2) will give 1, because there is only 1 "2" in that list

AVERAGEIF =averageif(range-containing-criteria,criteria,range-to-base-average-on) =countif(B1:B10,"B",A1:A10) will give 6, because all the values with B (2+4+6+8+10)/5 = 6

SUMIF =sumif(range-containing-criteria,criteria,range-to-sum) =sumif(B1:B10,"B",A1:A10) will give 30, because all the values with B (2+4+6+8+10) = 30

Hope that helps a bit?