Jul 26 2022 08:48 AM
Hello
I have attached 2x sheet screenshots below - one called 'target' which I want to put the formula in and one called ''source' which is where is want to pull the info from
What is the right formula/function to use sum the amount of complaints
(column H in "Target" by customer UPC column b in "target")
I want to sum the complaints form source but this is dependent on the customer UPC and w/e date - these values should match and shared in both sheets below
Jul 26 2022 11:44 AM
How about
=SUMIFS(ABC!$M$2:$M$1000, ABC!$D$2:$D$1000, B2, ABC!$L$2:$L$1000, E2)
Adjust the ranges if you have more than 1000 rows of data.
Jul 27 2022 12:15 AM
thanks
it's still giving me a '0' value so the formula is working just not picking up my value in the 'source' column
is there anything else i am doing that could be causing the error?
Jul 27 2022 12:18 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Jul 27 2022 12:37 AM - edited Jul 27 2022 01:06 AM
no problem, i have attached a sheet below
I have deleted data out of this leaving only the 2 sheets I want to look up from and the one I want to put info in
*link removed*
Jul 27 2022 12:50 AM
SolutionThe formula in ABC!M2 is
=IF(OR(O2="Positive"),"0",IF(OR(O2="Negative"),"1"))
Jul 27 2022 12:50 AM
SolutionThe formula in ABC!M2 is
=IF(OR(O2="Positive"),"0",IF(OR(O2="Negative"),"1"))