Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Please help me with Excel formula

Comment:

My need is a formula that runs thru a sheet and picks out and tallys codes based on certain criteria. For example: if I would like to get the total number of 'code1' entries that equal the number 2 that were entered on Monday (Day #2 of the week) I would use this formula. =IF(ISNA(MATCH(1,(EXPORTSUMMARY!A2:A60=2)*(EXPORTSUMMARY!B2:B60=2),0)),0,INDEX(EXPORTSUMMARY!C2:C60,MATCH(1,(EXPORTSUMMARY!A2:A60=2)*(EXPORTSUMMARY!B2:B60=2),0))) Information located in cells A:Day of the week B:Code1 C:Number of Code1 for that day D:Code2 E:Number of Code2 for that day My problem is that I need to figure out how to have the formula check the 'Code2' cells and include the additional counts if they apply to the match.

Corrupted Outlook Persona...

Creating a word/excell ma...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Please help me with excel... i have this IMAGE http://img14.imgspot.com/u/07/183/1... and when i pasted it into EXCEL it gives me this result: http://img14.imgspot.com/u/07/183/1... how can i do pleas...

Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...

Summary: For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying information only. Also, summed columns of figures are no...