LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aaron Saulisberry
 
Posts: n/a
Default Will SUMPRODUCT work for this?

I'm currently using the following formula to calculate certain cells in the
range only if they match in two columns. It works fine for getting a grand
total.

=SUMPRODUCT(--Logbook!T3:T65536<""),--(Logbook!U3:U65536<""),Logbook!T3:T65536))

But I'd like to be able to break this down by month in the date column.

Ex:

A B C
3-Jan 15 30
5-Jan 8 8
3-Mar 13 19
9-Mar 5 5
7-Jul 10 10
2-Jul 6 4

The values in columns B & C must match in order to be accepted. I'm stuck on
how to break it down by month only.

Not sure if this is important or not but not every row has a date or figure.

As always, help is greatly apprreciated!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DIV/0! error in SumProduct formula with no division Irrational Excel Worksheet Functions 1 August 18th 05 01:39 AM
Tab key don't work in unprotected cells in a protected sheet Chad Excel Discussion (Misc queries) 0 August 16th 05 02:00 AM
Some Excel links don't work Ben Enfield Excel Discussion (Misc queries) 3 August 2nd 05 12:29 AM
creating an invoice for work Beth Excel Worksheet Functions 4 July 16th 05 09:25 PM
Sumproduct HELP Victoria4338 Excel Worksheet Functions 4 July 1st 05 10:18 AM


All times are GMT +1. The time now is 03:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"