Hello,
I am seeking help on the following problem:
<tbody>
</tbody>
I need to write a formula for cells F2:Q2 that calculate the following:
For example - in cell F2
If F1 = A2 then F2=D3 + If F1 = B2 then F2=D3 = If F1 = C3 then F2=D3
So, let's say Cells A2:C2 all contained "Jan", then cell F2 would equal "9". On the other hand, based on the current values of cells A2:C:2, cell a2=3, g2=3, and h2=3.
Let me know if I need to clarify as I am aware this may seem confusing.
Thanks!
I am seeking help on the following problem:
a | b | c | d | f | g | h | i | j | k | l | m | n | o | p | q | |
1 | Upgrade 1 | Upgrade 2 | Upgrade 3 | # employees | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
2 | Jan | Feb | Mar | 3 |
<tbody>
</tbody>
I need to write a formula for cells F2:Q2 that calculate the following:
For example - in cell F2
If F1 = A2 then F2=D3 + If F1 = B2 then F2=D3 = If F1 = C3 then F2=D3
So, let's say Cells A2:C2 all contained "Jan", then cell F2 would equal "9". On the other hand, based on the current values of cells A2:C:2, cell a2=3, g2=3, and h2=3.
Let me know if I need to clarify as I am aware this may seem confusing.
Thanks!