Formula + a general inquiry. Maybe someone can try and help. Thanks

[pedie]

Formula does not work. I am trying to count how many Dsx are there on weekday 6 that is fri from the range.

=COUNTIFS((WEEKDAY(A2)=6,B2:B4="Dsx")

And one more question please.
Whenever we begin to type a formula in a cell for instance =T we get suggestion pop up like text, time, tan etc etc...my question is
is there a way to select without having me to write the whole word or without having me to use the mouse?

 

[doofusboy]

Whenever we begin to type a formula in a cell for instance =T we get suggestion pop up like text, time, tan etc etc...my question is
is there a way to select without having me to write the whole word or without having me to use the mouse?

With the intellisense option you want highlighted, just hit the Tab key.

 

[MrKowz]

Don't think you need COUNTIFS for this:

=IF(WEEKDAY(A2)=6,SUMIF(B2:B4,"=Dsx"),"")

 

[jasonb75]

Don't think you need COUNTIFS for this:

=IF(WEEKDAY(A2)=6,SUMIF(B2:B4,"=Dsx"),"")

I can't see SUMIF working either.

Maybe

=sumproduct((weekday(a2:a4)=6)*(b2:b4="dsx"))

The original request is a little vague.

 

[MrKowz]

That would work. You never defined that the WEEKDAY function was supposed to look at a range.

Another way to write the SUMPRODUCT function:

=SUMPRODUCT(--(WEEKDAY(A2:A4)=6),--(B2:B4="Dsx"))

 

[pedie]

Thanks alot! it works perfect that way.

Thanks again everyone for helping