| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct
Hi all,
I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct
You can still use SUMPRODUCT
=SUMPRODUCT(--(B2:B556="L")) or you could use a COUNTIF function =COUNTIF(B2:B556,"L") If these don't work for you, post your formula, and I, or someone else, can help :) -- ** John C ** "Bryan De-Lara" wrote: Hi all, I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct
=SUMPRODUCT(--(A1:A100="L"), --(B1:B100="cats))
this will count how may row have the letter L in A and word cats in B For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bryan De-Lara" wrote in message ... Hi all, I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct
I feel so stupid now, I tried using it and I couldn't get it to work. I
pasted yours and it works a treat. Thank you John for such a quick turnaround. No doubt I will have another question later that has baffled me for the past year. Bryan. "John C" <johnc@stateofdenial wrote in message ... You can still use SUMPRODUCT =SUMPRODUCT(--(B2:B556="L")) or you could use a COUNTIF function =COUNTIF(B2:B556,"L") If these don't work for you, post your formula, and I, or someone else, can help :) -- ** John C ** "Bryan De-Lara" wrote: Hi all, I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct
Thanks for the feedback, and don't forget to mark the question answered :)
-- ** John C ** "Bryan De-Lara" wrote: I feel so stupid now, I tried using it and I couldn't get it to work. I pasted yours and it works a treat. Thank you John for such a quick turnaround. No doubt I will have another question later that has baffled me for the past year. Bryan. "John C" <johnc@stateofdenial wrote in message ... You can still use SUMPRODUCT =SUMPRODUCT(--(B2:B556="L")) or you could use a COUNTIF function =COUNTIF(B2:B556,"L") If these don't work for you, post your formula, and I, or someone else, can help :) -- ** John C ** "Bryan De-Lara" wrote: Hi all, I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct
Silly question, how do I mark it answered?
Bryan "John C" <johnc@stateofdenial wrote in message ... Thanks for the feedback, and don't forget to mark the question answered :) -- ** John C ** "Bryan De-Lara" wrote: I feel so stupid now, I tried using it and I couldn't get it to work. I pasted yours and it works a treat. Thank you John for such a quick turnaround. No doubt I will have another question later that has baffled me for the past year. Bryan. "John C" <johnc@stateofdenial wrote in message ... You can still use SUMPRODUCT =SUMPRODUCT(--(B2:B556="L")) or you could use a COUNTIF function =COUNTIF(B2:B556,"L") If these don't work for you, post your formula, and I, or someone else, can help :) -- ** John C ** "Bryan De-Lara" wrote: Hi all, I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct
It depends on how you access the help group. Some give stars, some give
little yes boxes below, and some????? who knows :) Either way, glad to have helped. -- ** John C ** "Bryan De-Lara" wrote: Silly question, how do I mark it answered? Bryan "John C" <johnc@stateofdenial wrote in message ... Thanks for the feedback, and don't forget to mark the question answered :) -- ** John C ** "Bryan De-Lara" wrote: I feel so stupid now, I tried using it and I couldn't get it to work. I pasted yours and it works a treat. Thank you John for such a quick turnaround. No doubt I will have another question later that has baffled me for the past year. Bryan. "John C" <johnc@stateofdenial wrote in message ... You can still use SUMPRODUCT =SUMPRODUCT(--(B2:B556="L")) or you could use a COUNTIF function =COUNTIF(B2:B556,"L") If these don't work for you, post your formula, and I, or someone else, can help :) -- ** John C ** "Bryan De-Lara" wrote: Hi all, I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct
I use windows mail, and not given any of those options, so sorry but my
question was answered. "John C" <johnc@stateofdenial wrote in message ... It depends on how you access the help group. Some give stars, some give little yes boxes below, and some????? who knows :) Either way, glad to have helped. -- ** John C ** "Bryan De-Lara" wrote: Silly question, how do I mark it answered? Bryan "John C" <johnc@stateofdenial wrote in message ... Thanks for the feedback, and don't forget to mark the question answered :) -- ** John C ** "Bryan De-Lara" wrote: I feel so stupid now, I tried using it and I couldn't get it to work. I pasted yours and it works a treat. Thank you John for such a quick turnaround. No doubt I will have another question later that has baffled me for the past year. Bryan. "John C" <johnc@stateofdenial wrote in message ... You can still use SUMPRODUCT =SUMPRODUCT(--(B2:B556="L")) or you could use a COUNTIF function =COUNTIF(B2:B556,"L") If these don't work for you, post your formula, and I, or someone else, can help :) -- ** John C ** "Bryan De-Lara" wrote: Hi all, I have a workbook that I use sumproduct in. But this only counts numeric's. How can I count (L). If I try to use sumproduct obviously it reports 0. I need to count from B2 TO B556 in a column. Any help would be appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| =SUMPRODUCT | Excel Worksheet Functions | |||
| IF/AND used with SUMPRODUCT? | Excel Worksheet Functions | |||
![Bryan De-Lara[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
