Jan 26 2022 01:40 PM
What is the formula for counting and then subtract if value is text?
Example: I want to count if the name is column G is "Francine" and subtract .5 if the word in comlun E says Agency.
Name Name | Job 1 | City A | Manager 1 | Referral | Francine | January | |
Name Name | Job 2 | City A | Manager 1 | Agency | 2/14/22 | Francine | January |
Name Name | Job 2 | City B | Manager 2 | InMail | 1/24/22 | Francine | January |
Jan 26 2022 01:58 PM
For example:
=SUMPRODUCT((G1:G25="Francine")/(1+(E1:E25="Agency")))
Adjust the ranges as needed.
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.