[Solved] Sum Charges $9 If Vendor Name Appeared

Discuss the spreadsheet application

[Solved] Sum Charges $9 If Vendor Name Appeared

Postby ROLC » Thu Aug 15, 2019 4:44 am

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
ROLC
 
Posts: 2
Joined: Thu Aug 15, 2019 4:09 am

Re: Sum Charges $9 If Vendor Name Appeared

Postby FJCC » Thu Aug 15, 2019 12:30 pm

If I understand you correctly, I would use a helper column as shown in the attached file.
Attachments
CountIf.ods
(8.31 KiB) Downloaded 10 times
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7789
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Sum Charges $9 If Vendor Name Appeared

Postby ROLC » Fri Aug 16, 2019 4:06 am

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
ROLC
 
Posts: 2
Joined: Thu Aug 15, 2019 4:09 am


Return to Calc

Who is online

Users browsing this forum: Majestic-12 [Bot] and 30 guests