Menu

formula help

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.misc

sross002

sross002 is offline

external usenet poster

Posts: 29

Default

Try this

thanks.

"Gilbert" wrote:

Try the following formula

=SUMIF(D4:G4,"Y",D6:G6)+SUMIF(D5:G5,"Y",D6:G6)

Replace D4:G4 & D5:G5 with your Y and N rows and replace D6:G6 with the
values row.

Reply With Quote

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

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement