danielstone121
New Member
- Joined
- Feb 14, 2013
- Messages
- 45
Hey!
So, I have a cell in my spreadsheet with the following function:
=COUNTIFS($O$7:$AX$7,">="&$A$4,$O$7:$AX$7,"<="&$B$4)
It is counting the number of cells in the range O7 through AX 7 that contain dates that fall between the dates in A4 and B4. What I was wondering is if I can subtract another Count formula result from this one.
The other count formula is going to count the number of cells in the range O to AX that contain "S", so I'll probably use this formula:
=COUNTIF(O8:AX8,"S") for row 8 and ones like it for each row below.
Can I somehow combine these two formulas? Meaning, can I subtract the value from the CountIf formula from the value of the CountIfS formula?
Please let me know if you need more information. Also, is there a way to attach my spreadsheet so that you can look at it, or is that not something this site allows? Thanks in advance for the help!
So, I have a cell in my spreadsheet with the following function:
=COUNTIFS($O$7:$AX$7,">="&$A$4,$O$7:$AX$7,"<="&$B$4)
It is counting the number of cells in the range O7 through AX 7 that contain dates that fall between the dates in A4 and B4. What I was wondering is if I can subtract another Count formula result from this one.
The other count formula is going to count the number of cells in the range O to AX that contain "S", so I'll probably use this formula:
=COUNTIF(O8:AX8,"S") for row 8 and ones like it for each row below.
Can I somehow combine these two formulas? Meaning, can I subtract the value from the CountIf formula from the value of the CountIfS formula?
Please let me know if you need more information. Also, is there a way to attach my spreadsheet so that you can look at it, or is that not something this site allows? Thanks in advance for the help!
