Counting values for variables in separate columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
=SUMPRODUCT(--('Project Master'!G82:G369="Gap"),
--('Project Master'!F82:F369="SME"))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
=SUM(COUNTIF('Project Master'!G82:G369,"gap"),COUNTIF('Project
Master'!F82:F369,"sme"))

HTH
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Countif 2
Counting unique values in column 3
Count the columns from one sheet and paste it in another sheet 0
counting text rows in columns 4
counting blank cells within two columns 2
sum number of columns based on variable value 4
VBA: How can I use a string variable as autofilter criteria? 4
counting formula 8

Back
Top