SumIFS Questions

Kheinrich119 · #1 12-10-2012, 02:34 PM

I am having problem trying to write the equation that will sum up the total of hours listed in Column F if Column C = "PSL" but only if Column D is blank.

This one works for just summing everything equal to "PSL" in Column C
=SUMIF(C2:C29,"PSL",F2:F29)

Now I need to make it only sum if Column D is blank. Any suggestions?

Thanks,
Karen

Colin Legg · #2 12-10-2012, 03:35 PM

There is a subtle difference between these two, but both probably do what you need:

Code:

=SUMIFS(F2:F29, C2:C29,"PSL", D2:D29, "=")
or
=SUMIFS(F2:F29, C2:C29,"PSL", D2:D29, "")

The first formula will only sum when the cells in column D are completely empty. The second formula will only sum when the cells in column D are completely empty or contain a zero length string.

Kheinrich119 · #3 12-12-2012, 10:00 AM

Thank you the first equation work and did the job that I needed done.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Two questions - pdf and pictures	Brahman	PowerPoint	0	12-04-2012 04:52 PM
Few questions...needs some help!	Wolf.Stalker	Outlook	1	02-21-2012 09:15 PM
A couple of questions	Huge	Excel	2	06-07-2011 07:51 AM
Two questions from a novice	alexB	Word	0	08-11-2010 08:47 AM
Help needed using the serial number date with sumifs - whole office is stumped	FraserKitchell	Excel	3	01-06-2010 12:24 PM