sum if question
 

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.

sum if question
 

=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.

sum if question
 

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.

sum if question
 

I think I have it

I can't do it in 1 cell because it's an array but try:

=SUMPRODUCT((A1:A20="Authfee")*(B1:B20=9.99)*(B1:B 20))

Enter with control + shift + enter
You can change Authfee and yhr 9.99 for other values
but remember to re-enter with Ctrl+Shift+Enter

to get the count of items dive the answer this gives by 9.99.

Mike

"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.

sum if question
 

=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.

sum if question
 

sorry ... should read your question more carefully ..

=SUMPRODUCT(--(A2:A100="Authfee"),--(B2:B100=9.99))

=SUMPRODUCT(--(A2:A100="Authfee"),--(B2:B100=29.99))

"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.

sum if question
 

SUMPRODUCT is entered with Enter not Ctrl+Shift+Enter

=SUMPRODUCT(--(A1:A20="Authfee"),--(B1:B20=9.99)) will give count

"Mike H" wrote:

I think I have it

I can't do it in 1 cell because it's an array but try:

=SUMPRODUCT((A1:A20="Authfee")*(B1:B20=9.99)*(B1:B 20))

Enter with control + shift + enter
You can change Authfee and yhr 9.99 for other values
but remember to re-enter with Ctrl+Shift+Enter

to get the count of items dive the answer this gives by 9.99.

Mike

"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.