Conditional Formula, I think?

[Jorja]

Hello: I am trying to write a formula to calculate per diem based on the number of days that someone worked AND add an additional day if the person worked 5 or 6 days. Right now I have the following to just count the number of days they have worked:
=COUNTIF(R14:X14,"<>0>)
This returns the result that I am wanting EXCEPT that I need it to add an additional day if they worked 5 days for a total of 6 or if they worked 6 days then a total of 7. HELP! I am at a loss!
TIA

 

[jtakw]

Hi,

Assuming you have either 0 (zero) or any number other than 0 in R14:X14

Book1
	R	S	T	U	V	W	X	Y
14	1	1	0	0	1	1	1	6
Sheet387

Cell Formulas
Range	Formula
Y14	=IFERROR(CHOOSE(COUNTIF(R14:X14,"<>0"),1,2,3,4,6,7,8),0)

EDIT: updated formula for in case the employee didn't work that week.

 

[Jorja]

Thank you so much, jtakw! I have changed it to reflect that. I appreciate it!

 

[jtakw]

You're welcome, welcome to the forum.