Hi
I hope someone is going to have a simple answer for a countifs query i have need resolving.
I have a long spreadsheet (1400 lines) which someone has 'been using' badly, and i need to count if certain words are used in a column.
i need to count light fittings unfortunately the person who entered it all in put model numbers (all in column E) in that no longer exist so i need to count them if the field has 600x600 and 40w as well as a having an x in column H
I have got =COUNTIFS(Sheet1!E:E,B3,Sheet1!H:H,"X") (B3 has the text of 600x600 1 x 40w EBMCFP140Z) to work, but with this would need copy every different entry in to a single column
does this make sense and if so (phew) is there a way?
Thank you for saving the headache
Regards
Matthew
I hope someone is going to have a simple answer for a countifs query i have need resolving.
I have a long spreadsheet (1400 lines) which someone has 'been using' badly, and i need to count if certain words are used in a column.
i need to count light fittings unfortunately the person who entered it all in put model numbers (all in column E) in that no longer exist so i need to count them if the field has 600x600 and 40w as well as a having an x in column H
I have got =COUNTIFS(Sheet1!E:E,B3,Sheet1!H:H,"X") (B3 has the text of 600x600 1 x 40w EBMCFP140Z) to work, but with this would need copy every different entry in to a single column
does this make sense and if so (phew) is there a way?
Thank you for saving the headache
Regards
Matthew