BanderSnatch
New Member
- Joined
- May 16, 2016
- Messages
- 4
Hi,
I have been trying (and failing!) to use the countif function for a heatmap.
In some cases there are two types of text data from a call log system that I need to extrapolate from the cells; I also need to do it between months of the year. For example;
C D
<colgroup><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" width="75"><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" width="75"><tbody>
</tbody>
The formula i've tried is;
=COUNTIFS('Call Log'!$D$15:$D$999,"LM",'Call Log'!$D$15:$D$999,"Louise")*(MONTH('Call Log'!$C$15:$C$999)=4)
But the result is always coming back at 0. Am I missing something glaringly obviuous , is there anthing I can use in its place or do simpler? (for info the data starts at D15 and ends at D999).
Any help is gratefully received!
Thanks all
I have been trying (and failing!) to use the countif function for a heatmap.
In some cases there are two types of text data from a call log system that I need to extrapolate from the cells; I also need to do it between months of the year. For example;
C D
Date Call Generated | Raised By |
01/04/2016 | JC |
10/04/2016 | LM |
13/04/2016 | James |
22/04/2016 | LM |
29/04/2016 | Louise |
09/05/2016 | JC |
15/06/2016 | LM |
16/06/2016 | Louise |
20/06/2016 | James |
<colgroup><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" width="75"><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" width="75"><tbody>
</tbody>
The formula i've tried is;
=COUNTIFS('Call Log'!$D$15:$D$999,"LM",'Call Log'!$D$15:$D$999,"Louise")*(MONTH('Call Log'!$C$15:$C$999)=4)
But the result is always coming back at 0. Am I missing something glaringly obviuous , is there anthing I can use in its place or do simpler? (for info the data starts at D15 and ends at D999).
Any help is gratefully received!
Thanks all