Apache OpenOffice Community Forum

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 4.1.2
Windows 7 Professional

If I understand you correctly, I would use a helper column as shown in the attached file.

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))