we have two types of auth fees, so we need a count of the ones which are 9.99
and 29.99
so i col a is auth fee
in col B is 9.99 or 29.99

"Mike H" wrote:

Ann,

That is considerably less clear than the first question.

Col A = Activation fee. Straightforward text, i'm relaxed about that.
Col B = 9.99 or 29.99. We can't get mixed up over that, 1 of 2 values.

If auth/9.99 or auth/29.99 is very unclear and I'm lost.
Please re-clarify

Mike


"Ann" wrote:

sorry let me be more clear. column A will say activation fee and col b will
have either 9.99 or 29.99 so if auth/9.99 then i want it to sum those and if
auth/29.99 then i want it to sum those separately.

"Mike H" wrote:

Ann,

it's sumif

=SUMIF(A1:A4,"=1",B1:B4)

Chane 1 for 2 for the other values.

Mike

"Ann" wrote:

i want to sum the numbers in column B based on the criteria in column A and
give a count. not sure what the combo is.

Col A col b
1 9.99
1 9.99
2 10.00
2 30.00

so i want the result to show
1 19.98
2 40.00