| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting
i am afcing one problem
i want to count two prject in one cel Example A B Reefer PV Reefer PV Reefer Equate Reefer Equate Reefer L.D Reefer Supreme I Wnat To Count the Reefer belong to PV and Equate In One Cell A1, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting
With the datalist in A1 to B6, enter this in C1:
=Sumproduct((A1:A6="Reefer")*(B1:B6="PV")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Suleman" wrote in message ... i am afcing one problem i want to count two prject in one cel Example A B Reefer PV Reefer PV Reefer Equate Reefer Equate Reefer L.D Reefer Supreme I Wnat To Count the Reefer belong to PV and Equate In One Cell A1, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting
butt friend i need Pv and Equate in One Cel
I mena Reefer Belong tO Pv and Reefer Belong to Equate Both in one Cell You Formula Just able to count the reefer belong to Pv it will not count the equate reefer "RagDyer" wrote: With the datalist in A1 to B6, enter this in C1: =Sumproduct((A1:A6="Reefer")*(B1:B6="PV")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Suleman" wrote in message ... i am afcing one problem i want to count two prject in one cel Example A B Reefer PV Reefer PV Reefer Equate Reefer Equate Reefer L.D Reefer Supreme I Wnat To Count the Reefer belong to PV and Equate In One Cell A1, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting
Sorry, I misread.
Try this: =SUMPRODUCT((A1:A6="Reefer")*(B1:B6={"PV","Equate" })) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Suleman" wrote in message ... butt friend i need Pv and Equate in One Cel I mena Reefer Belong tO Pv and Reefer Belong to Equate Both in one Cell You Formula Just able to count the reefer belong to Pv it will not count the equate reefer "RagDyer" wrote: With the datalist in A1 to B6, enter this in C1: =Sumproduct((A1:A6="Reefer")*(B1:B6="PV")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Suleman" wrote in message ... i am afcing one problem i want to count two prject in one cel Example A B Reefer PV Reefer PV Reefer Equate Reefer Equate Reefer L.D Reefer Supreme I Wnat To Count the Reefer belong to PV and Equate In One Cell A1, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting
hi
try this =SUMPRODUCT((A14:A19="Reefer")*(B14:B19="PV")+(A14 :A19="Reefer")*(B14:B19="Equate")) regards FSt1 "Suleman" wrote: i am afcing one problem i want to count two prject in one cel Example A B Reefer PV Reefer PV Reefer Equate Reefer Equate Reefer L.D Reefer Supreme I Wnat To Count the Reefer belong to PV and Equate In One Cell A1, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Counting D,E,N | Excel Discussion (Misc queries) | |||
| Counting | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
![Suleman[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
