LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Complex Sumproduct formula

Hi Ray,

Am Tue, 2 Feb 2021 23:45:53 -0800 (PST) schrieb Ray Smart:


Effectively, my new table will look like:
itemtype, Nov, Dec, Jan, etc
Fee,?,?,?
Other,?,?,?
Allowable,?,?,?
Total,11077,60021, etc


have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgfAF...S1VOw?e=ehpuk8
Is that the expected result?


Regards
Claus B.
--
Windows10
Microsoft 365 for business
 
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
complex color fill conditions- if statements or complex formula? lilly8008 Excel Discussion (Misc queries) 1 December 18th 09 04:57 AM
Sumproduct forumla for complex sum. DocBrown Excel Programming 18 September 19th 09 02:03 AM
Sumproduct syntax - more complex Mitchell Excel Discussion (Misc queries) 4 November 9th 06 07:46 PM
a complex use of sumproduct ? pimar[_9_] Excel Programming 2 February 24th 06 11:39 AM
Help with Complex SUMPRODUCT formula Murph Excel Worksheet Functions 5 January 26th 05 02:40 PM


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