LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Elizabeth
 
Posts: n/a
Default Formula that only adds numbers that meet specific criteria

Hi, I am trying to create a formula that adds certain values from Column B
only if Column A equals a certain criteria AND Column C equals a certain
criteria.

Column A Column B Column C

23 23.88 V
23 100.00 M
24 9.95 M
24 23.88 M
25 23.88 V
25 23.88 V
26 23.88 A
26 23.88 A
26 23.88 M
26 23.88 M
26 23.88 V
26 9.95 V
27 23.88 A

Specifically, I need the total from Column B for all M's on the 23rd, all
V's on the 23rd, etc. In Column D, I've tried many different formulas but
they either total the entire B Column (not just the cells that match the
criteria) or they only "sum" Column B for the row the formula resides on. Any
suggestions would be greatly appreciated.
 
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
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Need help creating a formula for a specific result Katybug Excel Discussion (Misc queries) 2 May 23rd 05 06:17 PM
What function will check a row for a series of specific numbers? PuzzledK Excel Discussion (Misc queries) 1 May 11th 05 09:20 PM
How do I create a formula to add values from specific fields? Greg Excel Worksheet Functions 1 December 14th 04 03:10 PM
How do I create a formula to add values from specific fields? cabodiamonds Excel Worksheet Functions 1 December 14th 04 04:53 AM


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