Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
& with COUNTIF | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |