count a range

K

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
 
F

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
 
K

kevin carter

Thank you
Frank Kabel said:
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
Click to expand...
 
Top