peo - i want a total of 2 variables, not 1.
if authfee and 9.99 then i want a total and a count
if authfee and 29.99 then i want a total and a count

"Peo Sjoblom" wrote:

=SUMIF(A:A,"authfee",B:B)

change accordingly for the tranfee or use

=SUMIF(A:A,C2,B:B)

where you put the criteria in C2

to count them

=COUNTIF(A:A,"authfee")


--
Regards,

Peo Sjoblom



"Ann" wrote in message
...
that won't work since there's other types of fees which equals 9.99 .
here's
the entire spreadsheet layout

col A col B
Authfee 9.99
tranfee 9.99
authfee 9.99
authfee 29.99

so i want the totals to be
9.99 auth fees, 2 =19.98
29.99 auth fees, 1 = 29.99

"Mike H" wrote:

Could be:-

=COUNTIF(B:B,9.99) & " of 9.99 fees totalling "&SUMIF(B:B,"=9.99",B:B)&"
Dollars."

Substitute 9.99 * 29.99 for the other authorisation fee.

Mike

"Ann" wrote:

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