reckless2k2
New Member
- Joined
- Feb 5, 2007
- Messages
- 37
- Office Version
- 365
- Platform
- MacOS
I'll try my best to explain.
Sales tax is collected by store but returns tax is consolidated by region. I used the following formula with success:
=IF(ISNA(VLOOKUP(F11,RTNS,3,FALSE))=TRUE,0,VLOOKUP(F11,RTNS,3,FALSE))/(COUNTIF($F$10:$F$1281,F11))
The problem is that some stores do not have sales because they are closed.
How can I modify the formula to say only count if the sales for the particular line is greater than zero? I tried something like this instead of countif but it did not work:
=SUMPRODUCT(F10:F59=F16)--(O16>0)
Thanks for any help.
Sales tax is collected by store but returns tax is consolidated by region. I used the following formula with success:
=IF(ISNA(VLOOKUP(F11,RTNS,3,FALSE))=TRUE,0,VLOOKUP(F11,RTNS,3,FALSE))/(COUNTIF($F$10:$F$1281,F11))
The problem is that some stores do not have sales because they are closed.
How can I modify the formula to say only count if the sales for the particular line is greater than zero? I tried something like this instead of countif but it did not work:
=SUMPRODUCT(F10:F59=F16)--(O16>0)
Thanks for any help.
