[Solved] Sum Charges $9 If Vendor Name Appeared

Discuss the spreadsheet application
Post Reply
ROLC
Posts: 2
Joined: Thu Aug 15, 2019 4:09 am

[Solved] Sum Charges $9 If Vendor Name Appeared

Post 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
Last edited by ROLC on Fri Aug 16, 2019 4:14 am, edited 2 times in total.
OpenOffice 4.1.2
Windows 7 Professional
Top
FJCC
Moderator
Posts: 9277
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Sum Charges $9 If Vendor Name Appeared

Post by FJCC »

If I understand you correctly, I would use a helper column as shown in the attached file.
Attachments
CountIf.ods
(8.31 KiB) Downloaded 52 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Top
ROLC
Posts: 2
Joined: Thu Aug 15, 2019 4:09 am

Re: Sum Charges $9 If Vendor Name Appeared

Post 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))
OpenOffice 4.1.2
Windows 7 Professional
Top
Post Reply

Return to “Calc”