Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Problem
thats is my work sheet as you can see below file i apply diffrent formula for diffrent project i am using formula like that =SUMPRODUCT((Sheet4!I9:J286="=SUMPRODUCT((Sheet4!I 9:J286="Reefer")*(Sheet4!K9:L286="Recovery"))Reefe r")*(Sheet4!K9:L286="PV")) as you can see in one cell i count the reefer related to project PV and other cell count th reefer which related to Recovery Type Project Reefer PV Reefer PV Reefer PV Reefer PV Reefer PV Reefer Recovery Reefer Recovery Now I Need To Ask I want to count tow project in one cell Reefer PV Reefer Local Distribution Reefer Local Distribution Reefer PV i want that i to count reefer Which related to L.D or PV in One Cell Please i hope you understand my probelm do the need full |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
COUNT IF (AND / OR) SUM IF PROBLEM | Excel Worksheet Functions | |||
Count Problem | Excel Discussion (Misc queries) | |||
count problem | Excel Worksheet Functions |