Excel Formula

**mail2zain** · 28th May 2011, 07:54 AM

to all ITD members
mjy Excel Masters sy helop chaheyeeee. mjy MS Excel me aik proble hai mere pas 3 column hai js sy mjy kuch data collect karna hai by using equation/Formula. 3 column sy one figure laina es me countif and if use hoga likin mery sath sytax ka problem hai
i m using Office 2007
neechy me ny attach kya hai i need it.
thanks in advance.
ZAIN KHAN

excel.xls

Name: untitled.jpg
Views: 277
Size: 42.0 KB

***Black*Beauty*** · 28th May 2011, 11:04 AM

ATTACHMENT nhi hy.

**IT.BOY** · 28th May 2011, 12:02 PM

وعلیکم السلام
سکرین شارٹ شو نہیں ہو رہا ہے۔۔۔

**mail2zain** · 28th May 2011, 04:23 PM

yeh attachement teeeek kiya

**syar** · 28th May 2011, 10:52 PM

in B10

Code:

=SUMPRODUCT(--(A2:A8="plant"),--(B2:B8="ncr"),--(C2:C8="closed"))

In B11

Code:

=SUMPRODUCT(--(A2:A8="plant"),--(B2:B8="ncr"),--(C2:C8="open"))

Change your criteria accordingly like replace plant with camp and with road.

May be this will help you.

regards,

**mail2zain** · 29th May 2011, 12:26 PM

Thank you this is working with this sheeet but this was only for example i put there it is not working with my actual Log sheeeet
any way thank you very much for you co operation.

ZAIN KHAN