Hi All
Hopefully this is a simple one and I am just having brain fade
I am looking to count the product of two columns when greater than zero and extra condition
Column A is a reference (extra condition)
Column B is a positive or negative
Coulmn C is a positive or negative
So I am looking to count when both B and C are positive or are both negative with a condition in Coumn A
I have trying to use countifs combined with sumproduct, I know i can create extra column and use countifs but was hoping to tie it off without a column
Appreciate any help
Regards
Bookmarks