Counting items from two columns
Posted by Charles Marsh on September 12, 2000 5:35 PM
I have two columns and I need to get a count based on
1: if column a not = "" and column b = "In Process"
on the same row.
If you have any ideas, I would appreciate the help.
thanks,
charles
Posted by Charles Marsh on September 13, 0100 6:33 AM
thanks, but I don't think that I described the problem correctly. Here it is again.
In cell A1 I want a count of where cells b1:b5 are not equal to "" and cells c1:c5 are equal to "In Process". eg. at the end, my table would look like the following.
A B C
2 "" "In Process"
"1245" ""
"1230" "In Process"(this one is counted)
"1230" "Out of order"
"1235" "In Process"(this one is counted)
I hope that this makes more sense.
I look forward to your help.
Charles
Posted by Celia on September 13, 0100 4:45 PM
Charles
Did you try the formula I provided? It does what you want.
Just change the cell references to fit your example :-
=SUM((B1:B5<>"")*(C1:C5="In Process"))
Don't forget to enter by Ctrl+Shift+Enter
Celia
Posted by Ivan Moala on September 13, 0100 5:19 PM
OR if you are after the SUM of the values in A
then just change Celias one to;
=SUM(((A1:A14<>"")*(B1:B14="In Process")*(A1:A14)))
Ivan
Posted by Celia on September 12, 0100 6:10 PM
Charles
=SUM((A1:A14<>"")*(B1:B14="In Process"))
To enter the formula you must press Ctrl+Shift+Enter.
Celia
