Formula Help Please

[pure vito]

Hi All,

Could I ask for you help please, apologies in advance I do not understand how to use L2BB but I have added a link to the document,

Admittedly I'm not very good with formula, but what I want to achieve is G7 should show the amount of lieu days earned (J7) but starting from P7 if you type in "LT" it should deduct 8.5 Monday to Thursday but on Friday should deduct 5, I'm not sure if this is possible but because this will be a shared document I'm not sure it macros will work?

Thanks in advance.

holiday trackerr.xlsm

 

[FormR]

Hi, how about:

=J7-(COUNTIFS(M7:NK7,"LT",$M$5:$NK$5,"<>Friday")*8.5)-(COUNTIFS(M7:NK7,"LT",$M$5:$NK$5,"=Friday")*5)

 

[pure vito]

That's Fantastic, thank you so much for taking the time it's much appreciated.

 

[pure vito]

Hi @FormR, I'm wondering if you could possibly help me again with this formula please, the requirement has changed, rather than having the formula add the set value
I'd like to manually type in the value in each cell as an example I would type something like this "LT 5.5" rather than just "LT", hope this makes sense and again thanks for your help.

 

[FormR]

the requirement has changed

Responded here:

Formula to count specific text and value within a single cell?

Hi All, The formula would be in G10 and the range would be N10:NN10, If possible I would like the formula to count the specific text LT but to then count the value within the same cell also, for example "LT 10" would = 10 in G10, after searching google I've not come across an instance or answer...

www.mrexcel.com