Hello All,

i have a excel workbook with multiple worksheets, what i am trying to create now is "summary worksheet" which holds the calculated count of totals from different worksheets in same workbook.

what i am after is:

>> I have a user worksheet with all the information contain about user details that i am interested in. In my "User worksheet" i have two columns (I and J) which i want to count in my "Summary Worksheet".  

>> Column I of User worksheet contain information about years like 2007, 2010, 2012 and 2014. Column J contains information for version of software used like Professional, Standard, OEM, Bespoke. 

>> In Summary worksheet i want to count total number of software version used in particular year. like if I=2007 then how many versions of Professional, Standard and bespoke software is used.

 

i do not want to use VBA. Can someone help me in generating such a formula.

Thanks in advance.

Regards,

Hi Folks,

I managed to get the formula sorted.

I used SUMPRODUCT() function to get it worked.

Thanks

Ajay

Dear All, 

I hope if someone here can help me with a formula where I want to get how many days it is due. I want to subtract due dates with the current day and keeps on updating or incrementing with 1 on the next day. And, using Excel 2013 

Thanks to all who can help me with this in advance :) 

Regards,
Flava