Countif
I have two questions.
1st- Can someone tell me another way to write this statement? This is not
working for me and I don't understand why. This dashboard portion refers to
today's date [""&DASHBOARD!AD3] and it works fine. The problem is I need to
remove or exclude some of the other data so I can filter per Region and only
show "ICMS Request" values.
=COUNTIF('DATA (RAW)'!BH:BH,""&DASHBOARD!AD3)-COUNTIF('DATA
(RAW)'!N:N,"SUPPORT REQUEST")-COUNTIF('DATA (RAW)'!N:N,"WORK
ORDER")-COUNTIF('DATA (RAW)'!AQ:AQ,"EMEA")-COUNTIF('DATA
(RAW)'!AQ:AQ,"CALA")-COUNTIF('DATA (RAW)'!AR:AR,"CA")-COUNTIF('DATA
(RAW)'!AR:AR,"US")
2nd - Is there a way to count only the values that = today's date? The
following doesn't work:
=COUNTIF('DATA (RAW)'!BH:BH,"="&DASHBOARD!AD3)
Appreciate the help ... this report is killing me!
|