Add up values of a specific month based on status

**BartDeHertogh** · 09-30-2010, 04:44 AM

Hi,

Is there a SUMIF or other formula to add up values from one column based on the criteria of a month and on the status ?

See example.

Thanks,
B

!

**zbor** · 09-30-2010, 04:53 AM

I've created for you Pivot table with vertical and horizontal output in each sheet so choose what better suit for you.

**BartDeHertogh** · 09-30-2010, 04:58 AM

Hi,
Thanks zbor... but I'm looking for a formula (no pivot, no VBA) to calculate this sheet.
+ pivots don't work under shared docs (Sorry I should have mentionned it was a shared doc)

**zbor** · 09-30-2010, 05:42 AM

Here then...

Note that I changed table slightly for simplier formula.

**BartDeHertogh** · 09-30-2010, 07:22 AM

Super ! Thanks, just what I needed

Add up values of a specific month based on status

LinkBack

Thread Tools

Rate This Thread

Display

Add up values of a specific month based on status

Re: Add up values of a specific month based on status

Re: Add up values of a specific month based on status

Re: Add up values of a specific month based on status

Re: Add up values of a specific month based on status

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions