Text Equal Hours Formula

[edlorowa]

I've started been a roster rep a work and I started a spreadsheet so I need a formula for when ever I type in RDO in a cell it will equal 7 hours and addup towards my end of week total hours

[boopathiraja]

Hi, Welcome to the forum

Where a1 = where you type RDO
A2= Result my end of week total hours

A3=

Please Login or Register  to view this content.

[JBeaucaire]

You could use a COUNTIF() formula to count the instances of "RDO" in a range of cells of your choosing. Then you multiply that by 7.

For example:

=COUNTIF(A4:A20, "RDO") * 7

[edlorowa]

Thanks for the Tips Guys

[boopathiraja]

Hi, there is no attachment, besides you can upload a small sample of a workbook instead of a PIC,

[edlorowa]

new to the whole forum thing can you give us an idea how to upload a small workbook sample

[JBeaucaire]

Attach a sample workbook. Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[edlorowa]

here we go excel Problems.xlsx

[samba_ravi]

=COUNTIFS(C$2:AD$2,"<>o/t",C$2:AD$2,"<>trav",C$2:AD$2,"<>s",C4:AD4,"RWO")*7
Try this in "AE4"

[edlorowa]

Cheers mate worked a treat can I add a sum formula to the one you just gave us excel Problems.xlsx I tried that and failed

[samba_ravi]

What you are trying to do in Column AE

[edlorowa]

Column AE will have the Total Hours that a certain person have done for the week

[edlorowa]

I've added a example of the workbook on what i'd like to do excel Problems.xlsx