Forum Discussion
Solved
SUMIF function
Hi all, I am unable to use Sumif function to sum up my Revenue due to the criteria is not matched. Eg: I have an salesperson his UID is 500008, his UID in year is 500008_SG. So when i try ...
merson82 Use this one in stead:
=SUMPRODUCT(D4:D23*(ISNUMBER(FIND(F5,A4:A23))))
or transform the ID's to Text and use a wildcard in the SUMIF formula.
=SUMIF(A4:A23,F5&"*",D4:D23)
File attached with both options.
merson82 Use this one in stead:
=SUMPRODUCT(D4:D23*(ISNUMBER(FIND(F5,A4:A23))))
or transform the ID's to Text and use a wildcard in the SUMIF formula.
=SUMIF(A4:A23,F5&"*",D4:D23)
File attached with both options.
Hi Riny,
Thank you so much. This is really helpful 🙂 If I would like to sum up only total revenue by Year 2021 by salesperson can I use SUMIFS/ SUMIF function? Any suggestion that I can do this?
Thank you so much. This is really helpful 🙂 If I would like to sum up only total revenue by Year 2021 by salesperson can I use SUMIFS/ SUMIF function? Any suggestion that I can do this?