count a range

[kevin carter]

hi
i am trying to count an occurance of a text value over a date range
i have the following formula

SUMPRODUCT(($A$1:$A$350>=Q44)*($A$1:$A$350<=R44),$E$1:$E$350)
this works fine
what i want to do is only show the number of occurences for cell t42 (text
value)
i have tried the formula below but it is not working
SUMPRODUCT(($A$1:$A$350>=Q44)*($A$1:$A$350<=R44)*(TEXT(T42,)),$E$1:$E$350

where am i going wrong


thanks in advance

kevin

 

[Frank Kabel]

Hi Kevin
in which column of your data range is T42?
You should change your formula to something like
SUMPRODUCT(($A$1:$A$350>=Q44)*($A$1:$A$350<=R44)*($X$1:$X$350=T42),$E$1
:$E$350)

change column X to your column

 

[kevin carter]

Thank you

Hi Kevin
in which column of your data range is T42?
You should change your formula to something like
SUMPRODUCT(($A$1:$A$350>=Q44)*($A$1:$A$350<=R44)*($X$1:$X$350=T42),$E$1
:$E$350)

change column X to your column