Taking totals based on criteria. Is this possible?

**BigBas** · 02-24-2007, 02:01 PM

(See attachment below)

I'm developing a spreadsheet that calculates totals earnings gross and net for a group of employees daily. Basically, I have the whole thing developed. On sheet 2, I would like to pull just the weekly totals out of sheet 1. I have tried vlookups, and Index/match formulas, but its hard to get it to pull the info correctly.

Any help of suggestions?

**davesexcel** · 02-24-2007, 02:27 PM

This should work;

paste these formulas starting in Sheet2 B3

Please Login or Register  to view this content.

**Carim** · 02-24-2007, 02:32 PM

Hi,

With the structure of sheet1, use following offset formula, in sheet2 cell B3:

Please Login or Register  to view this content.

**BigBas** · 02-24-2007, 03:24 PM

Carim,

Thanks for your help. Your formula worked wonderfully!

**Carim** · 02-24-2007, 03:30 PM

Glad it fixed your problem ...

Thanks for the feedback

Taking totals based on criteria. Is this possible?

LinkBack

Thread Tools

Rate This Thread

Display

Taking totals based on criteria. Is this possible?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions