I have text in columns A, C, E, G and numbers in columns B, D, F, H
I have used conditional formatting to identify duplicate words (in this case ERF).
I need a formula to add the values in the columns adjacent to the word ERF. (B3, B4, D5, D6, F1, etc)
A B C D E F G H
1 VLF 10 CFC 25 ERF 3.85 0
2 VLF 4 CFC 10 ERF 1.54 0
3 ERF 2.4 SSU 8 TBS 0.04 VLF 3.2
4 ERF 1.8 SSU 6 TBS 0.03 VLF 2.4
5 VLF 0.84 ERF 0.6 0 0
6 CFC 8 ERF 1.2 0 0
7 CFC 3.5 PAS 1 VLF 0.75 ERF 0.5
8 CFC 24 VLF 10 ERF 1.68 0
Bookmarks