if then statement based on another column

Posted to microsoft.public.excel.worksheet.functions

ann

external usenet poster

Posts: 210

if then statement based on another column

i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200)
if column C is one of 4 statements. how do i use both?
for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Multiple If Then Statement based on ranges	Multiple If, Then statements	Excel Worksheet Functions	5	November 18th 09 07:08 PM
MSGBox based on If Statement	tony	Excel Discussion (Misc queries)	2	February 9th 07 06:40 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look	[email protected]	Excel Discussion (Misc queries)	1	December 27th 06 05:47 PM
If Statement based on blank fields	alaxmen	Excel Worksheet Functions	3	February 8th 06 08:00 PM
Msgbox based on If statement	Neil Jimack	Excel Worksheet Functions	2	May 11th 05 11:22 PM

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

Menu

About Us