Help please quickly
Closed
Will
-
Sep 9, 2009 at 06:39 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 13, 2009 at 01:06 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 13, 2009 at 01:06 AM
Hello,
I have a list of categories in column a (such as taxi, bus, train, plane, etc) and in column b (a y if they have planned the travel) I want a formula that lets me know how many planned journeys have been taken by taxi, plne , boat, etc) Hope this makes sense
I have a list of categories in column a (such as taxi, bus, train, plane, etc) and in column b (a y if they have planned the travel) I want a formula that lets me know how many planned journeys have been taken by taxi, plne , boat, etc) Hope this makes sense
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Sep 13, 2009 at 01:06 AM
Sep 13, 2009 at 01:06 AM
use sumif
syntax
SUMIF(range,criteria,sum_range)
where critera is "=" & cell reference to taxi...
syntax
SUMIF(range,criteria,sum_range)
where critera is "=" & cell reference to taxi...