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
[Solved] Sumproduct if
[Solved] Sumproduct if
Last edited by Hagar Delest on Thu Jun 04, 2020 7:19 am, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
openoffice 4.1
Re: Sumproduct if
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Sumproduct if
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
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
Re: Sumproduct if
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.