LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Multiple Criteria for SumIf

I would like to sum the total of a category between two dates. There are a
number of posts but I can't seem to get it to work. I created the following;

SUMIF('YTD Data'!D:D,M3,'YTD Data'!B:B)&SUMIF('YTD Data'!A:A,"="&M1,'YTD
Data'!B:B)-SUMIF('YTD Data'!A:A,""&M2,'YTD Data'!B:B)

But it does not work very good because the sum is "text", it can not be
formated and if 0 it gives a "text value".

Any help is appreciated.
Ronbo
 
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
multiple SUMIF criteria Markl9869 Excel Worksheet Functions 4 October 10th 08 03:20 PM
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria kazoo Excel Discussion (Misc queries) 2 August 21st 08 06:22 PM
SUMIF with multiple criteria Plum Excel Discussion (Misc queries) 4 April 21st 07 06:31 PM
SumIf with Multiple Criteria DEE Excel Worksheet Functions 4 November 21st 06 10:04 PM
SUMIF with multiple criteria for multiple columns to sum a single SavageMind Excel Programming 1 July 27th 05 03:34 PM


All times are GMT +1. The time now is 05:10 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"