I am currently using the following formula:
=COUNTIF(E24:AB24,"A")*2
as a way to caculate hours for me.
What I need it to do now is that if there is a "B" there to caculate it as 1.
Is there a way to do this?
I am currently using the following formula:
=COUNTIF(E24:AB24,"A")*2
as a way to caculate hours for me.
What I need it to do now is that if there is a "B" there to caculate it as 1.
Is there a way to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks