Can any "Excel Nut" help me with the formulae for the following ?
I am a novice with Excel & cannot work out how to obtain what I am after, I have tried Help & looked in the Excel User Guide book with out success.
I only have office 97 at this stage, can it do what I want ?
I can get for example =SUMIF(C3:C530,2,E3:E530) this gives me the sum of the value of cells in Col E3 to E530 only IF corresponding cells in Col C3 to C530 value is 2. But if I also want to add AND (IF B3:B530,4) AND (IF D3530,3) no matter how I bracket or colon or coma the formula it will not accept the formula saying error or too many functions.
So what I am after in above example is to sum the value of the cells in Col E only when value in corresponding cell of Col C is 2 but only when value in corresponding cell of Col B is 4 and the value of the corresponding cell in Col D is 3.

Similarly for COUNT & COUNTIF eg =COUNTIF(F3:F500,6) gives me the number of cells in Col F3 to F500 with a value of 6. But can I add AND (IF N3:N500,12) and (IF E3:E500,3)
So what I am after in above example is to count the number of times 6 occurs in Col F but only when corresponding cell in Col N is 12 and the corresponding cell in Col E is 3.

Any assistance much appreciated
With Thanks

__________________
DeeJay