LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
knbsmith11
 
Posts: n/a
Default Conditional Statement Question

I need a formula for the following synario:

Column A = either AG, AP or WW
Column B = %
Column C = Amount
and I have 4500 rows of data below

What I want to do is say if column A = AG, than multiply column B by Column
C and add up all the rows that meet the criteria and put them in this cell.

Can anyone help?
 
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
Conditional Worksheet Access Question RUSS Excel Worksheet Functions 0 January 10th 06 08:14 PM
Conditional formating on if statement SCOOBYDOO Excel Worksheet Functions 2 November 30th 05 06:58 PM
Conditional Statement in Charts smck Excel Worksheet Functions 2 November 12th 05 03:38 AM
Conditional Formatting Using If Statement On Opening Of Workbook Bill Foley Excel Worksheet Functions 11 October 19th 05 11:18 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM


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