Count Problem

Suleman

Guest

Posts: n/a

16th Jun 2008

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!I9:J286="Reefer")*(Sheet4!K9:L286="Recovery"))Reefer")*(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

« Setting a reminder | mouse pointer »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count duplicats, display incremental count, restart count at changein value	JenIT	Microsoft Excel Programming	2	24th Aug 2010 09:10 PM
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	Enda80	Microsoft Excel Misc	1	3rd May 2008 10:52 AM
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	Enda80	Microsoft Excel Worksheet Functions	0	3rd May 2008 01:04 AM
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	Enda80	Microsoft Excel Programming	0	3rd May 2008 01:03 AM
how to get count(col1), count(col2), count(sol3) with only one query	Mario Krsnic	Microsoft Access Queries	2	27th Oct 2006 06:52 PM