Is the CRS name constant in column C?
If so you could an IF statement:
=IF(LEFT($A2,3)="CRS",SUMI
Copy down and then apply conditional formatting based on the CRS again for the total rows.
Thanks
Rob H
Title | # Comments | Views | Activity |
---|---|---|---|
How can I sort the data shown in Sheet 1 and copy it to Sheet 2? | 8 | 19 | |
Modifying Conditional Format from VBA code | 3 | 29 | |
Dynamic Vlookup Function Formula Help | 4 | 13 | |
Find the last position of specific character in a cell Excel | 7 | 0 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!