Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing 2 columns
I can't seem to figure this out...here's an example spreadsheet.
1 blue red 2 red red 3 blue blue 4 red red 5 red blue I trying to get the sum of red only when red is equal in both columns. In this case the the total would be 2. I tried count and sum if but I think my syntax is all wrong. Thanks so much.............. Terry |
#2
|
|||
|
|||
=SUMPRODUCT(--(A1:A100="red"),--(A1:A100=B1:B100))
-- HTH RP (remove nothere from the email address if mailing direct) "TBoe" wrote in message ... I can't seem to figure this out...here's an example spreadsheet. 1 blue red 2 red red 3 blue blue 4 red red 5 red blue I trying to get the sum of red only when red is equal in both columns. In this case the the total would be 2. I tried count and sum if but I think my syntax is all wrong. Thanks so much.............. Terry |
#3
|
|||
|
|||
YOU! YOU! Your good! You my man are a genius. Many, many thanks.
Now! Can you point me to a good website so I can understand that formula? Thanks again Terry "Bob Phillips" wrote: =SUMPRODUCT(--(A1:A100="red"),--(A1:A100=B1:B100)) -- HTH RP (remove nothere from the email address if mailing direct) "TBoe" wrote in message ... I can't seem to figure this out...here's an example spreadsheet. 1 blue red 2 red red 3 blue blue 4 red red 5 red blue I trying to get the sum of red only when red is equal in both columns. In this case the the total would be 2. I tried count and sum if but I think my syntax is all wrong. Thanks so much.............. Terry |
#4
|
|||
|
|||
Indeed I can
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH RP (remove nothere from the email address if mailing direct) "TBoe" wrote in message ... YOU! YOU! Your good! You my man are a genius. Many, many thanks. Now! Can you point me to a good website so I can understand that formula? Thanks again Terry "Bob Phillips" wrote: =SUMPRODUCT(--(A1:A100="red"),--(A1:A100=B1:B100)) -- HTH RP (remove nothere from the email address if mailing direct) "TBoe" wrote in message ... I can't seem to figure this out...here's an example spreadsheet. 1 blue red 2 red red 3 blue blue 4 red red 5 red blue I trying to get the sum of red only when red is equal in both columns. In this case the the total would be 2. I tried count and sum if but I think my syntax is all wrong. Thanks so much.............. Terry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not summing a columns? | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Summing values of corresponding columns | Excel Worksheet Functions | |||
Summing values of corresponding columns | Excel Worksheet Functions | |||
Summing values of corresponding columns | Excel Worksheet Functions |