SUMIF over multiple ranges

**Karroog** · 03-17-2011, 07:27 PM

I have a list of 7 individuals who will be filling out what they have done during a shift. I've broken down their work into 10 generalized tasks. I am trying to find a way to add up the total amount of work done for a certain generalized task. The easy part was coming up with SUMIF for one person:

=SUMIF($A$3:A19,G24,$B$3:B19)

G24 = Task 1
Column A = Task Type
Column B = Amount done

Finds the "Task 1" instance and adds up the row it correlates to.

My question would be how do I perform the same function within 7 different ranges but adding it up into 1 specific cell?

Thanks for the help!

**shg** · 03-17-2011, 07:42 PM

I'll move this thread unless you tell me it's an Outlook question.

=SUMIF(...) + SUMIF(...) + ...

**Karroog** · 03-17-2011, 07:45 PM

Originally Posted by shg

I'll move this thread unless you tell me it's an Outlook question.

=SUMIF(...) + SUMIF(...) + ...

Holy crap, I can't believe I put this in the outlook forum. I am so sorry. Please move!!

**MarvinP** · 03-17-2011, 07:47 PM

Hi,
Does the following attached help or make sense?

**Karroog** · 03-17-2011, 07:56 PM

Originally Posted by MarvinP

Hi,
Does the following attached help or make sense?

Hi Marvin:

Yes it does! Go go Pivot tables.

SHG also had a good point as well, and I might actually use both examples within this question and another I had! Saved another forum post!

Thanks guys!