Multi Problem with dates

[rooneyjohn]

Hello to all helpful people!! In advance, I really apperciate your time checking out my problem.

I want to be able to use
Col A as Types (three different types, lets say Big Med and Small)
Col B as Dates (within the months of April May June)
Col C as Yes No
Col D used just as names
Col E, F, G as Count collums (April May Jun respectively)

A ______B _________C _____D ___E ___F __G
_____________________________April May June
Big __6/15/2011 ___YES___ Big ____0 __0 __1
Sm __5/15/2011 ___YES ___Med ___0 __0 __0
________________________SM ____0 __1 __0

So I need a way that when I put info in A,B,C that it looks at the A for type, then the date and if YES in C, it counts it in proper field.

Thanks in Advance!

 

[MikeWx]

This formula, copied into Cell E2 through G4, will give you your counts. I changed the value in D4 to Sm to match the value in Column A, and assumed you had at least 10 rows of data. Increase the end of each range to the actual number of rows in your data.

<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>E2</TD><TD>=SUMPRODUCT(--($A$2:$A$10=$D2),--(TEXT($B$2:$B$10,"mmmm")=E$1),--($C$2:$C$10="YES"))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Mike

 

[rooneyjohn]

I will try this first thing tomorrow morning when I get to work!
Thank you very much!

I'm actually looking to look through the entire column, but I think I can see how to change the code to make that happen.

Again, Thank you very much for such a speed response!