Page 1 of 1

[Solved] Sum Charges $9 If Vendor Name Appeared

PostPosted: Thu Aug 15, 2019 4:44 am
by ROLC
Hi All,

The result I am aiming for is total rentas charges when specific vendor's name appeared.

There is $9 rentas charge every time a specific vendor's name appeared in column C. I tried the first row C4 with vendor's name "Rainbow" and it works, but it stop working from row C5 onward.

Can anyone please advise where did I go wrong? Thank you very much.

OpenSource Sum IF.png


OpenSource 4.1.2
Windows 7 Professional

Re: Sum Charges $9 If Vendor Name Appeared

PostPosted: Thu Aug 15, 2019 12:30 pm
by FJCC
If I understand you correctly, I would use a helper column as shown in the attached file.

Re: Sum Charges $9 If Vendor Name Appeared

PostPosted: Fri Aug 16, 2019 4:06 am
by ROLC
Hi FJCC,

Thank you for your reply, and for pointing me to the right direction in your attached file.

I have figured out the formula that I needed, which is:
=SUMPRODUCT(COUNTIF(H1:H5;C4:C8))