|
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, |
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, |
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, |
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, |
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, |
| All times are GMT +1. The time now is 03:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com