|
Counting values for variables in separate columns
Sorry I'm back with another question, and not sure if it will be picked up at
the end of my last string, so I'm adding this in as a new question - sorry I'm a rookie to the Discussion Forum.... I'm working on a spreadsheet and thought the same forumla would work (it worked for preivous formula when numbers where involved). This time I'm checking two seprate column and want to count the number of results if the value in one field is Gap and the value in the other column is SME or variables as I define. Would you take a quick look at this formula and see where I'm going wrong - sorry! =SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project Master'!F82:F369=SME)) |
Counting values for variables in separate columns
=SUMPRODUCT(--('Project Master'!G82:G369="Gap"),
--('Project Master'!F82:F369="SME")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "MMcQ" wrote in message ... Sorry I'm back with another question, and not sure if it will be picked up at the end of my last string, so I'm adding this in as a new question - sorry I'm a rookie to the Discussion Forum.... I'm working on a spreadsheet and thought the same forumla would work (it worked for preivous formula when numbers where involved). This time I'm checking two seprate column and want to count the number of results if the value in one field is Gap and the value in the other column is SME or variables as I define. Would you take a quick look at this formula and see where I'm going wrong - sorry! =SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project Master'!F82:F369=SME)) |
Counting values for variables in separate columns
|
Counting values for variables in separate columns
=SUM(COUNTIF('Project Master'!G82:G369,"gap"),COUNTIF('Project
Master'!F82:F369,"sme")) HTH -- Allllen "MMcQ" wrote: Sorry I'm back with another question, and not sure if it will be picked up at the end of my last string, so I'm adding this in as a new question - sorry I'm a rookie to the Discussion Forum.... I'm working on a spreadsheet and thought the same forumla would work (it worked for preivous formula when numbers where involved). This time I'm checking two seprate column and want to count the number of results if the value in one field is Gap and the value in the other column is SME or variables as I define. Would you take a quick look at this formula and see where I'm going wrong - sorry! =SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project Master'!F82:F369=SME)) |
Counting values for variables in separate columns
Super job thanks, it's good for a novice like me to get the correct forumla
too, all I had to do was cut and paste it in "Bob Phillips" wrote: =SUMPRODUCT(--('Project Master'!G82:G369="Gap"), --('Project Master'!F82:F369="SME")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "MMcQ" wrote in message ... Sorry I'm back with another question, and not sure if it will be picked up at the end of my last string, so I'm adding this in as a new question - sorry I'm a rookie to the Discussion Forum.... I'm working on a spreadsheet and thought the same forumla would work (it worked for preivous formula when numbers where involved). This time I'm checking two seprate column and want to count the number of results if the value in one field is Gap and the value in the other column is SME or variables as I define. Would you take a quick look at this formula and see where I'm going wrong - sorry! =SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project Master'!F82:F369=SME)) |
Counting values for variables in separate columns
the count if didn't seem to work, I had to use the Sumproduct option
"Allllen" wrote: =SUM(COUNTIF('Project Master'!G82:G369,"gap"),COUNTIF('Project Master'!F82:F369,"sme")) HTH -- Allllen "MMcQ" wrote: Sorry I'm back with another question, and not sure if it will be picked up at the end of my last string, so I'm adding this in as a new question - sorry I'm a rookie to the Discussion Forum.... I'm working on a spreadsheet and thought the same forumla would work (it worked for preivous formula when numbers where involved). This time I'm checking two seprate column and want to count the number of results if the value in one field is Gap and the value in the other column is SME or variables as I define. Would you take a quick look at this formula and see where I'm going wrong - sorry! =SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project Master'!F82:F369=SME)) |
Counting values for variables in separate columns
Never mind.
-- Allllen "MMcQ" wrote: the count if didn't seem to work, I had to use the Sumproduct option "Allllen" wrote: =SUM(COUNTIF('Project Master'!G82:G369,"gap"),COUNTIF('Project Master'!F82:F369,"sme")) HTH -- Allllen "MMcQ" wrote: Sorry I'm back with another question, and not sure if it will be picked up at the end of my last string, so I'm adding this in as a new question - sorry I'm a rookie to the Discussion Forum.... I'm working on a spreadsheet and thought the same forumla would work (it worked for preivous formula when numbers where involved). This time I'm checking two seprate column and want to count the number of results if the value in one field is Gap and the value in the other column is SME or variables as I define. Would you take a quick look at this formula and see where I'm going wrong - sorry! =SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project Master'!F82:F369=SME)) |
| All times are GMT +1. The time now is 02:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com