Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a web query that's working well when I'm importing a single datum into
a cell. =SUMIF('Query Data'!$E:$E,$B23 & E$1,'Query Data'!$D:$D) What I need to be able to do is to add the results of the query data of two separate data (B23 and C23) into a single cell. Sometimes B23 will have data, sometimes C23 will have data, sometimes both will. I've tried ($B23+$C23) and ($B23:$C23) but get nothing, even when both have data. Can someone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumif Query | Excel Discussion (Misc queries) | |||
SumIf query ... | Excel Worksheet Functions | |||
changing query source | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) |