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

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


"Ann" wrote:

this is what i want:
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



"Toppers" wrote:

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

"Ann" wrote:

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.