How do I include a SUMIF in a IF(AND statement?

**johnw993** · 12-05-2012, 01:35 AM

I'm trying to pull data from a sheet within my workbook which is populated by using a VBA Userform. This (Database) sheet works fine and contains everything I need. I've named the columns in the database sheet. In a different sheet I'm trying to extract data from this sheet by using this formula:
=IF(AND($C$3=Name,$C$5=Department,$C$4=Week),SUMIF(Work,$C15,Monday),0)

The cells C3, C4 and C5 are entry fields in this sheet (from lookup tables to match exactly the conventions used in the data sheet). Cell C15 is static data looking for a match in the "Work" range.
I'm not getting the results it should produce.

Thoughts?

**FDibbins** · 12-05-2012, 01:55 AM

try using 1 of the new functions included in 2007 onwards...sumifS() from the sounds of it, that will give you what you want

**johnw993** · 12-05-2012, 02:17 AM

Thanks FDibbins, I'm using MSOffice 2011 for the MAC and tried all latest features. The sumifS is not doing the job either. I'm missing something somewhere. Feel rather stupid, as I've been able to do this before.

**Teethless mama** · 12-05-2012, 02:29 AM

Post your workbook

**johnw993** · 12-07-2012, 10:49 PM

SIMIFS did indeed work. Thank you for making me aware of this!

**FDibbins** · 12-07-2012, 11:00 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)