View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
neda5
 
Posts: n/a
Default sumif with two conditions

Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code 06 06 06 07 07 07
1 - - - - - -
2 - 5 - - - -
3 - 5 7 - - -
4 - 5 7 - - -
5 - 5 - 7 7 -
6 - 3 7 - 7 -
7 - 2 7 - 7 -

Can anyone help me?
Thanks in advance.
Neda