LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 275
Default Easy Sumproduct or Sumif - but I can't remember how ..lol !

Hi
I am having a slight memory block with this, I know its easy but can't
remember how to do it.

Column A is populated with dates in formatt dd mmmm yy eg 10 March 07
Column G is populated with invoice amounts as £0.00


can somebody put me out of my misery and advise who to search down column A
for a date eg 10 March 07 and total all the cells found through column G
If possible the formula should be able to be dragged down so that I can
tally up each seperate day of the month easily
 
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
sumif or sumproduct? ronnomad Excel Worksheet Functions 5 August 7th 06 10:13 PM
probably an easy one but... (using SUMPRODUCT?) ren_juanjo New Users to Excel 5 August 6th 06 04:45 PM
I know this is easy but I don't remember how. punter Excel Discussion (Misc queries) 5 June 16th 06 07:05 PM
sumif and sumproduct together tina Excel Discussion (Misc queries) 3 March 8th 06 01:39 PM
sumif or sumproduct Jim Excel Worksheet Functions 2 January 6th 06 01:02 PM


All times are GMT +1. The time now is 01:01 PM.

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"