Forum Discussion
Solved
Excel help
I was having an issue with a column of "if" statements in my spreadsheet. I was wanting to get a total of true "if" statements for that week. Each day of the week has =IF(F6<=TIME(12,0,0),"*","") t...
Kjharris123 The asterisk is seen as a wildcard character, so everything gets counted. Use "x" rather than "*" to mark and count the qualifying entries.
Kjharris123 The asterisk is seen as a wildcard character, so everything gets counted. Use "x" rather than "*" to mark and count the qualifying entries.
Yatzeee! that worked thanks for the insight!!!!!!!Riny_van_Eekelen