When the field is =N, want to subtract that field
Solved/Closed
Related:
- When the field is =N, want to subtract that field
- Input field text color - Guide
- Far-field voice interaction samsung - Guide
- Battle field 2042 download - Download - Shooters
- ..To.... field in yahoo mail problem ..double mail received - Yahoo Mail Forum
- Convert a date field in excel to day of week ✓ - Excel Forum
3 responses
Easiest solution is to have another cell, and calculate for N. Now subtract that total from the sum above. Speed to market and low tech!
Of course, you can always create your own function in VBA, and use it.
Would you like to use something like:
=COUNTENTRY(RANGE,FIRST_VALUE_TO_TEST_FOR,SECOND_VALUE_TO_delete)
Of course, you can always create your own function in VBA, and use it.
Would you like to use something like:
=COUNTENTRY(RANGE,FIRST_VALUE_TO_TEST_FOR,SECOND_VALUE_TO_delete)
I was able to work through the process and came up with this formula.
=(COUNTIFS(TRACKER!$D$3:$D$94,"=A",TRACKER!E$3:E$94,"=X"))/(COUNTIFS(TRACKER!$D$3:$D$94,"=A")-(COUNTIFS(TRACKER!$D$3:$D$94,"=A",TRACKER!E$3:E$94,"=N")))
Problem solved.
=(COUNTIFS(TRACKER!$D$3:$D$94,"=A",TRACKER!E$3:E$94,"=X"))/(COUNTIFS(TRACKER!$D$3:$D$94,"=A")-(COUNTIFS(TRACKER!$D$3:$D$94,"=A",TRACKER!E$3:E$94,"=N")))
Problem solved.
Its funny...I had almost the same thing needed in my office this morning, and when I thought about it, the working formula is exactly what you posted as the fix. Great job. Thanks for the return and the solving, as I was delighted to read you had figured it out. I was returning to post the subtraction portion, and you beat me to it!
Thanks again!
Thanks again!