| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Tab question | Excel Worksheet Functions | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
| =if QUESTION | Excel Discussion (Misc queries) | |||
Hybrid Mode
