Hi guys!
I would like to do something, what I think is basic, but it looks like Excel disagrees. I already red all the posts on the "HOW TO get SUMIF with autofilters to work", but to be honest all the OFFSET, ROW, COLUMN, MIN, MAX just confuse me even more.
So here my question that I hope, somebody can answer within seconds:
I have a list and filter it with Autofilter. In this list there is one Column that contains positive as well as negative Values. Now i would like to have a Summary-Part at the top showing me how many positive numbers are in the list and how many negative.
without the Autofilter this works:
So basically i want the same function, just to consider the autofilter.
I would be very thankful for a hint. I have not gotten anywhere during the last 2 hours ...
Best Regards,
Robert
I would like to do something, what I think is basic, but it looks like Excel disagrees. I already red all the posts on the "HOW TO get SUMIF with autofilters to work", but to be honest all the OFFSET, ROW, COLUMN, MIN, MAX just confuse me even more.
So here my question that I hope, somebody can answer within seconds:
I have a list and filter it with Autofilter. In this list there is one Column that contains positive as well as negative Values. Now i would like to have a Summary-Part at the top showing me how many positive numbers are in the list and how many negative.
without the Autofilter this works:
Code:
=SUMIF(D17:D1000;">0")
=SUMIF(D17:D1000;"<0")
I would be very thankful for a hint. I have not gotten anywhere during the last 2 hours ...
Best Regards,
Robert