Multi criteria large speadsheet

[atcman]

I have 80 rows, 365 columns broken into weeks with coded inputs. Can a formula be written to count 6 to 8 different items per row and total by week. The formula would need to count things like DN, ND, DF4, DL4, NF4, NL4

 

[Anand Sharma]

Hi,

You can use below formula to sum different words between two dates

=SUM(COUNTIFS(F1:F24,{"DN","ND","DF4"},E1:E24,">="&E1,E1:E24,">="&E2))

E1 and E2 are two dates

 

[atcman]

Thank you very much. Sorry for taking so long to reply, your formula worked great but been sick with the flu and just got to work today. Again thanks so much, Atcman