Re: using sumif function with mutliple criteria

From: Myrna Larson (anonymous_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Mon, 27 Sep 2004 22:27:46 -0500

Just curious, but is there some reason you are avoiding AND, i.e.

  =IF(AND(A1=4,B1=5),C1,0)

On Mon, 27 Sep 2004 22:01:03 -0500, dave22q
<dave22q.1d9wil@excelforum-nospam.com> wrote:

>
>kind of brute force but simple way is to create col for each of the 70
>subtotals you need. in ea col use an if statement to only enter items
>which fit that row hen use sum function to total the cols.. should be
>fairly easy to report in a 7x 10 table format. eg. if a1=4 and b1=5 are
>the codes we want for a particular cell the if statement would be-
>if(a1/4*b1/5=1,c1,0).