LinkBack URL
About LinkBacks
Hi I need some help with sumproduct & countif formula with 2 conditions
1. Yes/NO
2. Digits/Mix of Alphanumeric
I have attached a sample file highlighting yellow to show where formulas will go thanks.
Hi I need some help with sumproduct & countif formula with 2 conditions
1. Yes/NO
2. Digits/Mix of Alphanumeric
I have attached a sample file highlighting yellow to show where formulas will go thanks.
Last edited by tek9step; 02-16-2011 at 07:58 AM.
Cant get result using formula below
HTML Code:attached updated fileHTML Code:
Given 2003 requirement:
For rows 8 & 9 as above but revert ISNUMBER to ISTEXT
Please Login or Register to view this content.
though for rows 8 & 9 you might also consider use of COUNTIF (C) & SUMIF (D) based on B - subtracting appropriate value in rows 5 & 6 from resulting values
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks DO... what if i want to use sumproduct ( for column M which contains text & number) with condition as column M isnumber/istext.. I tried to use same principle but i guess the logic isnt working...
thanksHTML Code:
Not sure I follow the logic of your question... perhaps you mean:
Please Login or Register to view this content.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks