Feb 09 2022 07:02 AM
Hi all.
I'm not sure if this is possible but it doesn't hurt to ask, right?
I'm trying to create a formula that can work as follows:
IF (CELL RANGE) = X, THEN SUM (CELL RANGE) OF CELLS ADAJCENT TO X
So for example, I'm looking for a formula that can total all of Mike's hours from the hour column at any point that his name is added to the employee column.
this is as far as I've gotten =IF(CELL RANGE)="MIKE",
Any help would be greatly appreciated.
Thanks,
Michael
Feb 09 2022 07:09 AM
Solution=SUMIF(namerange, "MIKE", hoursrange)
Feb 09 2022 07:14 AM
@MNMAGEEpfa...I hope it resolves the issue.
Feb 09 2022 07:39 AM
Feb 09 2022 07:42 AM
Feb 09 2022 07:47 AM
Feb 09 2022 07:09 AM
Solution