A little bit lost adding a third criteria to the following formula:
=SUM(IF(MOD(ROW('2008 Errors'!$A$3:$A$3000),10)=3,IF((YEAR('2008
Errors'!$A$3:$A$3000)=2008)*(MONTH('2008 Errors'!$A$3:$A$3000)=1)*
(LEN('2008 Errors'!P3:P3000)-LEN(SUBSTITUTE('2008
Errors'!P3:P3000,"KT",""))0),1)))

too add that a further range of cells ('2008 Errors'!B3:B3000) with the
criteria "Fax" occuring in them (and in the month of January in A3-A3000 and
"KT" in P3:P3000 as detailed in the formula above) would then produce a
cumulative result as the obove formula does for the two criteria...getting
mixed up with my brackets etc
Cheers

What was wrong with my offering of yesterday?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"GD" wrote in message
...
A little bit lost adding a third criteria to the following formula:
=SUM(IF(MOD(ROW('2008 Errors'!$A$3:$A$3000),10)=3,IF((YEAR('2008
Errors'!$A$3:$A$3000)=2008)*(MONTH('2008 Errors'!$A$3:$A$3000)=1)*
(LEN('2008 Errors'!P3:P3000)-LEN(SUBSTITUTE('2008
Errors'!P3:P3000,"KT",""))0),1)))

too add that a further range of cells ('2008 Errors'!B3:B3000) with the
criteria "Fax" occuring in them (and in the month of January in A3-A3000
and
"KT" in P3:P3000 as detailed in the formula above) would then produce a
cumulative result as the obove formula does for the two criteria...getting
mixed up with my brackets etc
Cheers

Afernoon bob, apologies for not updating yesterday - got very snowed under.
I actually didn't get to the bottom of why that formula only produced a
result of 3, i'd amended the compacted range of cells and it gave no change.
In the end I settled on adding another column with extra data, which negated
the need for such a lengthy one as I worked out i'd need a similar
arrangement for about 20 formulas, it seemed simpler to add in a collum
exclusively stating KT or EL - it seems reliable so far.
It's using this column, cells P3-P3000 that i'm trying to draw a result for
text "KT", in the month of January in cells A3-A3000, and the word "Fax" in
cells B3-B3000...

Cheers
"Bob Phillips" wrote:

What was wrong with my offering of yesterday?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"GD" wrote in message
...
A little bit lost adding a third criteria to the following formula:
=SUM(IF(MOD(ROW('2008 Errors'!$A$3:$A$3000),10)=3,IF((YEAR('2008
Errors'!$A$3:$A$3000)=2008)*(MONTH('2008 Errors'!$A$3:$A$3000)=1)*
(LEN('2008 Errors'!P3:P3000)-LEN(SUBSTITUTE('2008
Errors'!P3:P3000,"KT",""))0),1)))

too add that a further range of cells ('2008 Errors'!B3:B3000) with the
criteria "Fax" occuring in them (and in the month of January in A3-A3000
and
"KT" in P3:P3000 as detailed in the formula above) would then produce a
cumulative result as the obove formula does for the two criteria...getting
mixed up with my brackets etc
Cheers

Can anyone offer any assistance on extending the below formula to depend on a
third criteria also?

Cheers

"GD" wrote:

Afernoon bob, apologies for not updating yesterday - got very snowed under.
I actually didn't get to the bottom of why that formula only produced a
result of 3, i'd amended the compacted range of cells and it gave no change.
In the end I settled on adding another column with extra data, which negated
the need for such a lengthy one as I worked out i'd need a similar
arrangement for about 20 formulas, it seemed simpler to add in a collum
exclusively stating KT or EL - it seems reliable so far.
It's using this column, cells P3-P3000 that i'm trying to draw a result for
text "KT", in the month of January in cells A3-A3000, and the word "Fax" in
cells B3-B3000...

Cheers
"Bob Phillips" wrote:

What was wrong with my offering of yesterday?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"GD" wrote in message
...
A little bit lost adding a third criteria to the following formula:
=SUM(IF(MOD(ROW('2008 Errors'!$A$3:$A$3000),10)=3,IF((YEAR('2008
Errors'!$A$3:$A$3000)=2008)*(MONTH('2008 Errors'!$A$3:$A$3000)=1)*
(LEN('2008 Errors'!P3:P3000)-LEN(SUBSTITUTE('2008
Errors'!P3:P3000,"KT",""))0),1)))

too add that a further range of cells ('2008 Errors'!B3:B3000) with the
criteria "Fax" occuring in them (and in the month of January in A3-A3000
and
"KT" in P3:P3000 as detailed in the formula above) would then produce a
cumulative result as the obove formula does for the two criteria...getting
mixed up with my brackets etc
Cheers