[Solved] Sumproduct if

Discuss the spreadsheet application
Post Reply
sharon29
Posts: 6
Joined: Sat Nov 30, 2019 6:19 pm

[Solved] Sumproduct if

Post by sharon29 »

hi column A1 to a99 has months of the year
B1 to B99 has numbers ,
I would like the total of numbers added to D1 if C1 is is the same month as A1 to A99.

example A4 = june, B4 =£105 C1= june so D1 would say £105
Hope someone can help
Last edited by Hagar Delest on Thu Jun 04, 2020 7:19 am, edited 1 time in total.
Reason: tagged solved
openoffice 4.1
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Sumproduct if

Post by FJCC »

I am not sure I understood correctly but try the following in D1

Code: Select all

=SUMPRODUCT(A1:A99=$C$1;B1:B99)
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.
sharon29
Posts: 6
Joined: Sat Nov 30, 2019 6:19 pm

Re: Sumproduct if

Post by sharon29 »

Yer that dont work for me, cant think how better to explain it.
basically d4 should only add rows where june it matched

a4 = june b4 = 105 c4= june so d4 should = 115
a5 = june b5 = 10
a6 = july b6 = 200
openoffice 4.1
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Sumproduct if

Post by FJCC »

Here is my example document. It only uses a few rows but I think it conveys the idea. If it is not similar to what you are trying to do, please post a document that shows your data. To post a file, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.
Attachments
SumSpecificMonth.ods
(8.71 KiB) Downloaded 117 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.
sharon29
Posts: 6
Joined: Sat Nov 30, 2019 6:19 pm

Re: Sumproduct if

Post by sharon29 »

Thanks alot that works great.
openoffice 4.1
Post Reply