Friday 27 March 2015

Salary total based on criteria where employee name starting with R or r

=SUMIF(A:A,UPPER("r") &"*",B:B)

In the above formula A:A is the range where employee names are stored and B:B contains salary.

No comments:

Post a Comment