sabledragonrook
New Member
- Joined
- Nov 9, 2015
- Messages
- 7
Hello all! Trying to pull something off here, but I'm not sure if it's possible. Below, 11/8/2015 is A9, 21 is C9, and 23 at the bottom there is C18.
<tbody>
</tbody>
From 21 down to 7 is one day's values. However, how many cells these values take up each day individually varies from day to day. I would like to create a complex IF function so that if the sum of all values occurring on a single day is >75, it will say "Budget Met" but if it is <75, it will say "Low Yield" in red. I can do all of this myself, except that I don't know how to account for the fact that, for example, on 11/8 there are 8 entries and on 11/9 there are 2. I was hoping there was a SUM function that could do the sum of all numerical values on X day. This is where I get a little lost, because if I'm just going to have to rewrite the IF function for the correct cells every day, I might as well do the math myself.
Help, anybody?
11/8/2015 | Wordy | 21 |
33 | ||
11 | ||
4.5 | ||
4.5 | ||
4.5 | ||
Max | 10 | |
300Editors | 7 | |
11/9/2015 | Wordy | 9 |
23 |
<tbody>
</tbody>
From 21 down to 7 is one day's values. However, how many cells these values take up each day individually varies from day to day. I would like to create a complex IF function so that if the sum of all values occurring on a single day is >75, it will say "Budget Met" but if it is <75, it will say "Low Yield" in red. I can do all of this myself, except that I don't know how to account for the fact that, for example, on 11/8 there are 8 entries and on 11/9 there are 2. I was hoping there was a SUM function that could do the sum of all numerical values on X day. This is where I get a little lost, because if I'm just going to have to rewrite the IF function for the correct cells every day, I might as well do the math myself.
Help, anybody?