Thread
:
IF Statements
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
IF Statements
Both fromulas work to COUNT, not SUM if BOTH columns meet the criteria on
the SAME row.
--
Don Guillett
SalesAid Software
"Bill Roberts" wrote in message
...
These formulas wanted to sum the two columns or multiply them. I am
wanting
to onlu sum one column if the other has a particular text in it.
"Bill Roberts" wrote:
I need to count items in one column when the word active appears in
another
column.
What I am trying to do is count all members who are "active" and who have
a
shunt. Active and Shunt are in different columns and I know that I could
just
filter the sheet by the columns, but I was hoping for an easier method.
By
developing a formula.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett