Excel Question - SUMIFS

Posted by Lorraine Meeks PM | on Mon, 09/07/2012 - 14:54 1611 17 comments | report

Hi,

I am trying to sum a column of values if two criteria are met but it is not working...

=SUMIFS('Kit List'!$H$5:$H$50,'Kit List'!$F$5:$F$50,$A$4,'Kit List'!$A$4:$A$49,B4)

I want to sum Kit List H5:H50 if

Condition 1: Kit list F5:F50 is equal to cell A4

and

Condition 2: Kit list A4:A49 is equal to cell B4

I have two worksheets,

First is Kit List, which has Month value in Column A , Variable in Column F and the costs that need to be summed in column H

Second is Payments, I have Supplier in A4 and the month value in B4.

Any help would be very appreciated!

Thanks

Comments

There are 17 comments. Login or register to view them.

So

ACDWebb | Mon, 09/07/2012 - 15:05

Hi,

Lorraine Meeks | Mon, 09/07/2012 - 15:24

How are you setting the Supplier name?

ACDWebb | Mon, 09/07/2012 - 15:42

The Variable in F definately

Lorraine Meeks | Mon, 09/07/2012 - 15:53

Lorraine!

Cantona1 | Mon, 09/07/2012 - 19:46

=SUMIFS('Kit List'!$H$5:$H$50

Cantona1 | Tue, 10/07/2012 - 21:43

I think that

ACDWebb | Mon, 16/07/2012 - 15:48

Test

sysmod | Fri, 13/07/2012 - 16:37

Suggestion

SteveRadcliffe | Fri, 13/07/2012 - 17:05

Works for me

gsgordon | Fri, 13/07/2012 - 17:20

Try Something like

sayersdave | Thu, 19/07/2012 - 10:58

5:50 v 4:49

lynamn | Thu, 19/07/2012 - 11:22

They don't need to match

gsgordon | Thu, 19/07/2012 - 11:31

I agree, but ...

lynamn | Thu, 19/07/2012 - 11:56

Try an array

sjt303 | Thu, 19/07/2012 - 15:20

There are over 15 replies to

Cantona1 | Thu, 19/07/2012 - 22:07

Agreed but ...

gsgordon | Fri, 20/07/2012 - 12:05