sum if question

A

Ann

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

Ann

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
 
M

Mike H

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:B20))

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
 
T

Toppers

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

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

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

Toppers

SUMPRODUCT is entered with Enter not Ctrl+Shift+Enter

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