- Joined
- Jan 7, 2013
- Messages
- 1
- Reaction score
- 0
Is there a way to make a statement that will count the following:
1. If cell g2 is populated, count 1in AF2
2. If cell g2 is populated AND cell h2 is populated, count 1 in AG2
These two I currently have with the following statements
IN AF2 I have =COUNTIFS($G2:$G29, $AD1, $H2:$H29, "")
In AG2 I have =COUNTIFS($G2:$G29, $AD1, $H2:$H29, ">0")
The last statement I need (i believe I will need to add on to the end of the first statement) will be a statement to add a tally if it equals to AD1, and the value in the "I" column on that row is less that the value in the "D" column of that row.
1. If cell g2 is populated, count 1in AF2
2. If cell g2 is populated AND cell h2 is populated, count 1 in AG2
These two I currently have with the following statements
IN AF2 I have =COUNTIFS($G2:$G29, $AD1, $H2:$H29, "")
In AG2 I have =COUNTIFS($G2:$G29, $AD1, $H2:$H29, ">0")
The last statement I need (i believe I will need to add on to the end of the first statement) will be a statement to add a tally if it equals to AD1, and the value in the "I" column on that row is less that the value in the "D" column of that row.