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
Was this post helpful