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: 2
Default How to list items meeting conditions?

Hello,

I have a spreadsheet with many children and their club dues. (It is
not very orderly.)
Names are in range B12 to B208 and their payments are in range F12 to
F208.
How can I write a formula that would create a list of all payments
made by "Brian Gumbs" .in another part of the spreadsheet?

eg
Brian G $23
Brian G $25
Brian G $50

(Windows XP, Excel 2003)

Thank you all,

OldMac
 
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
Meeting 12 formatted conditions Loadmaster Excel Discussion (Misc queries) 9 July 25th 08 03:16 AM
sum a range meeting conditions of row & column jwang036 Excel Worksheet Functions 2 April 21st 08 06:28 AM
using sumproduct on subtotals meeting certain conditions Jeff Manning Excel Worksheet Functions 0 November 10th 05 12:35 AM
Loop through cells meeting conditions Huyeote[_14_] Excel Programming 2 October 13th 05 03:25 PM
Meeting two conditions before summing Andeb Excel Worksheet Functions 1 June 24th 05 10:33 AM


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