[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 1 time
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: 7230
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: Google [Bot] and 11 guests