Count Problem

S

Suleman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 0
Counting 4
calculation problem 3
excel count problem 1
calculation problem 1
SUMPRODUCT 1
Help with Sumproduct searching cell contents 2
"Too many arguements for this function".....ohh nooo.... 2

Top