Ask a question Report

When the field is =N, want to subtract that field [Solved]

JBALLEST - May 30, 2018 at 10:00 AM - Latest reply: ac3mark 9419 Posts Monday June 3, 2013Registration dateModeratorStatus June 1, 2018 Last seen

- May 31, 2018 at 04:18 PM

Excel Ask a question Report

Hello,

This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that work?

=(COUNTIFS(TRACKER!$D$3:$D$94,"=A",TRACKER!E$3:E$94,"=X")/COUNTIFS(TRACKER!$D$3:$D$94,"=A"))

Your reply

Reply to this topic

3 replies

Report Respond to ac3mark

ac3mark 9419 Posts Monday June 3, 2013Registration dateModeratorStatus June 1, 2018 Last seen - Updated by ac3mark on 30/05/18 at 04:34 PM

Thank you

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)

Report Respond to JBALLEST

JBALLEST - May 31, 2018 at 07:04 AM

Thank you

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.

Report Respond to ac3mark

ac3mark 9419 Posts Monday June 3, 2013Registration dateModeratorStatus June 1, 2018 Last seen - May 31, 2018 at 04:18 PM

Thank you

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!

Your reply

Reply to this topic

Ask a question