Counting unique items...please help
NEVER MIND Duke - made a silly mistake - formula seems to be working great.
Thank you so much for the help!
"Lisa" wrote:
I mean a non-blank cell. In a new worksheet I am summarizing data from
corresponding worksheets. I tried the second formula you suggested, but I
think it is multiplying the values b/c I get an outrageously high number.
Should I be using something different then SUMPRODUCT???
"Duke Carey" wrote:
If by 'value' you mean a number, then
=SUMPRODUCT(--ISNUMBER(Q1:Q7),B1:B7)
If you mean a non-blank cell, then
=SUMPRODUCT(--NOT(ISBLANK(Q1:Q7)),B1:B7)
"Lisa" wrote:
I would like to create a formula that would add up a range of cells in column
B only if there is a value entered in Column Q. I've tried a couple of
things to no avail. Any suggestions???
|