Hi
I am trying to count if a cell is greater then Zero, with a criteria in a column and a row.
Column 1 has a persons name
Row 1 has the Current month
Row 2 has the day of the month
Row 3 has the # of item sold
For example Current month is there 31 times, since May has 31 days, June would be there 30 times etc. I need to count when Column 1 name matches and row matches, count how many times the sales are greater then 1
(I.e Countifs Name - Peter AND Month = 5 and Item Sold >0) [Month is numerical May=5,June=6)
Would prefer using a non array formula if possible since it may impact the calculations, but if that is the only solution then so be it
Thanks
I am trying to count if a cell is greater then Zero, with a criteria in a column and a row.
Column 1 has a persons name
Row 1 has the Current month
Row 2 has the day of the month
Row 3 has the # of item sold
For example Current month is there 31 times, since May has 31 days, June would be there 30 times etc. I need to count when Column 1 name matches and row matches, count how many times the sales are greater then 1
(I.e Countifs Name - Peter AND Month = 5 and Item Sold >0) [Month is numerical May=5,June=6)
Would prefer using a non array formula if possible since it may impact the calculations, but if that is the only solution then so be it
Thanks