AND IF Statement??? Not sure the formula to use

[bwhizz]

Hoping to get some help with this one.... I have a sheet of data and want to count how many oranges I have in total. I need to create a formula that counts the number of oranges. Keeping in mind that Cells C14, C30, C42 and C50 might change at any given time.

How do I create an if statement that counts the number of fruits if Cells C14,C30, C42 and C50 = Orange?

The Values of the fruits are always in Column G, one row under the row with the fruit

Cell C 14 Orange
Cell G15 3
Cell C30 Pear
Cell G31 5
Cell C 42 Apple
Cell G43 6
Cell C50 Orange
Cell G 51 8


Hope this makes sense
Thanks!

[jasoncw]

Try:

=SUMIF(C14:C50,"Orange",G15:G51)

HTH

Jason

[bwhizz]

Thanks for the reply, however can the sumif function be done with only select cells rather than a range of cells?

The formula:
=SUMIF(C14,C30,C42,C50,"Orange",G15,G31,G43,G51)

The above formula does not work -

Reason being is I have other #'s in Column G that I do not want to sum.

[daddylonglegs]

Is there any pattern to the cells you want to look at...or perhaps there is consistent text in column B for the rows you want to consider? E.g if you only want to look at column C when B says "fruit"

=SUMPRODUCT(--(B14:B50="fruit"),--(C14:C50="orange"),G15:G51)

[ChemistB]

Reason being is I have other #'s in Column G that I do not want to sum.

By that statement, do you mean that you have "Orange" in other cells in row C and don't want to include the value in G(+1) for those oranges?

If Not, then Jason's formula will work.

ChemistB